I have 2 Tables as follows
Switches
-> Switch
-> Location
Clients
-> Client Name
-> IP Address
-> Switch
-> Port
-> Location
I am using a drop down box on the clients table to relate the switch to that record. I want the Location on the Clients table to be automatically filled out depending on the switch that is selected. It should pull the location fron the Switch table and fill it out on the Clients table depending on which switch is selected from the drop down.
How can I do this?
