How to enact an action on multiple rows from a different table using multiple ref?

[anonymous]

Hi there,

I am trying to build an engine part inventory feature that changes one column to a predetermined value on the master inventory table from another table that is specifically for certain parts on certain engines. The problem that I am having is not being able to have the 2 tables know what they are referencing due to (what I believe) is the fact that the child table has multiple references in the cells of the ID column. Is there something I can do to have the app recognize that there are different references in an individual cell or is there a different way to approach this problem? Any suggestions are appreciated by myself and the grey hairs I’m getting from this issue.

Picture Order(Top->Down)

Child Table Columns

Child Table

Parent Table

Parent Table Columns

[WillowMobileSys]

@CRX_Brian

due to (what I believe) is the fact that the child table has multiple references in the cells of the ID column

May be not. It does appear you have condensed the number of tables but if you don’t need any other details that conflict with this structure it might be ok.

It looks to me like you have an “Engines” table and a “Parts Inventory” table and then are listing in a column on the “Engines” table the the parts associated with it. This is fine so long as you don’t need to have additional details about THAT part with THAT engine. For example, cylinders - an engine could have 1, 3, 4, 6, 8, 12, etc cylinders. If you needed to specify how many of the cylinder parts are associated with THAT engine, you couldn’t do it with this current table structure.

Setting aside the table structure observation above, you are thinking of the Parent/Child relationship backwards. The way you have your tables joined, the “Engines” table is the Parent and the “Parts Inventory” table is the child. Not sure if that helps you except to understand the answer to your question below.

NOW, to your question…

@CRX_Brian

Is there something I can do to have the app recognize that there are different references in an individual cell

Yes! The REF ID column on your “Engines” table needs to be set as type EnumList. Then inside that EnumList column definition, you can set the Base Type as Ref. This creates a list of Ref values that you can then treat as separate rows to operate on.

[anonymous]

Thank you so much, that was exactly it!