I'm working on a value list that I will be able to select error codes base on they type of equipment I'm entering for. Let me paint the DB for you
Table 1 = Equipment Type (EQ model number) --> Table 2 = Devices (EQ records assigned to location) --> Table 3 History (Error tracking on Devices)
On the layout for table 3 I have two portals to table 4 (Errors) and 5 (Parts Used)
I wanted to create another table to list out Error Codes and what Equipment they apply to (same with the parts) Because some error codes can apply to multiple eq. So based on the device model that I'm adding history for the error code and parts list should be dynamic. I've tried every which way to display based on relationships but no values will return.
Start Free Trial
