Hello all,
This is my Dev 101 question of the day.
I'm creating new tables in AX. I want to create 3 tables. Using my Cyborg theme for creating functionality to start tracking Cyborg Repairs. Here are the table definitions.
CyborgTypeTable - A setup table listing types. Contains 2 fields. A CyborgTypeID field which will be the index, and a Name field for a description.
CyborgClassTable - A setup table listing classes of cyborgs. Contains 4 fields. A ClassID field which will be the index, a CyborgName field for a description, a Version field, and a Type field which will relate back to the CyborgTypeTable as a normal relation with the intention of allowing the user to select via a drop down list the type from the CyborgTypeID field.
CyborgCustomerTable - a table to record Cyborgs being serviced in my fictional company. This table will have 4 fields. A CyborgCustID field which will be the table index, CustAccount which will be the customer account EDT, the CyborgClassID which be a normal relation with the intention of allowing the user to select via a drop down list the ClassID, and finally a CyborgTypeID field which I would like to populate from the relationship of the CyborgClassID record without the user selecting anything.
What would be the proper way to set up the relationships between the tables?
Are there any patterns such as this in AX I can reference?
Relation1 from the CyborgClassTable as a Normal Relation CyborgClassTable.CyborgTypeID == CyborgTypeTable.CyborgTypeID
Relation2 from the CyborgCustomerTable as a Normal Relation CyborgCustomerTable.CyborgClassID == CyborgClassTable.CyborgClassID
Relation3 from the CyborgCustomerTable. Would this be a Foreign Key relation > PrimaryKeybased?
Thanks in advance for your responses.
