Use entity property to pick data table for creating different type and number of entities

[jtdavis]

I have one data table to create Order entities(based on SimBit - Entity by data table).  Each order has properties such as type of Part and number of Parts.  Each Order entity needs to reference a Part data table (based on SimBit - Leveled Arrivals) for that type of Part to create all the part entities for that order.  Each Order type has an associated Part data table.

I'm not sure how to establish the relationship between the order entity and the correct part data table.  Any suggestions would be appreciated.  Thank you.

[CWatson]

Not sure which SimBit you are referring to for Entity by data table, but based on what you would like to do, using relational tables should help. Please review any of the Relational Tables SimBits (Using Relational Tables, Entity Follows Sequence with Relational Tables, etc.) - Basically, you would have a table that includes your Part names (materials or entity types) - that column would be 'Set Column As Key'. You could then have a related table that is your orders - which would have the order numbers and would use a foreign key property for the part number (thus multiple orders could reference the same part name).

You may wish to review one or more of the Scheduling examples (Examples under Support ribbon) as well, as those have multiple relational tables and deal with parts, components, orders, etc.