I am creating a table containing the different machines at a factory and a table with the electrical panels’ names to associate each machine to its electrical panel. I’ve now successfully linked the machines and panels. I am now trying to create a panel schedule for each panel.
- Is there a way to automatically link a table to other tables? (i.e: if I had 50 panels, it’s hard having to link 50 times)
- Is there a way to make sure that you only select a record once? (i.e: The dryer is connected to positions/slots 1,2,3 of panel PA, I want to make sure that I cannot choose those records again)
- Is there a way to prevent a record to be modified? (i.e: If a panel has 2 phases connected, I cannot connect a three phase motor)