I have a table called Project which has display column as Project Number.
I have a table called Main Equipment where the Project column has a relation with the Project Number of the Project table.
Now, I have created a table called Item List. What I want to do is have a column from where I can choose the Project Number and another column which will only show Equipment of that particular Project Number.
Example:
Table: Project
Project Number
3230
3229
Table: Equipment
Equipment Name | Project (taken from Project Table)
Heater | 3230
Pump | 3229
Motor | 3229
So in the Item List, if I create an Item called Pad Plate and choose Project as 3229, in the Main Equipment would show Pump and Motor and not Heater.
Hope I was able to explain my query.
Thanks!!