two tables relationship
Im developing this solution for a lighting audit application And I have two tables, one that holds all the current lighting and another that has all the new lighting..
I want it so after the user picks a current light it gives the option to choose a new light from a drop down list
How do I go about setting this up?
I have attached a picture to help visualize my point.. the frame on the left is where the user selects the current lights and the frame in the right is where you would pick the replacement lights..