AnsweredAssumed Answered

two tables relationship

Question asked by jlopezcabral on Sep 14, 2013
Latest reply on Sep 16, 2013 by philmodjunk


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..