Selecting one option from multiple tables 1

[JohnnyG23]

Ok, so I have three tables: CURRENT, Employees(linked), and School(Linked). Currently all three have an address but because of disputes the addresses vary. I was hoping to setup some kind of form were a user can select one of the address and that choice will be written into the CURRENT table. Like if CURRENT is 2323 Linwood and Employees is 2324 Linwood and School is 2123 Linwood the user will choose the correct value, say the value in Employees, and it will write that value to the CURRENT table. CURRENT and Employees are linked by the key value TechID. CURRENT and School are linked by the key value of Home_Dept, if that info is necessary.

Thus far I have tried a combo box, the form wizard and I can't get any of them to work for me. If anyone has any advise I would appreciate it. If any more information is needed please say so. Thanks.

 

[randy700]

Can you not just select a value from a combo box and run an update query?


Randy

 

[JohnnyG23]

I tried that an it only let me select one Table to pull values from and I need it to pull values from three tables.

 

[JohnnyG23]

Never mind. Guess I was just looking in the wrong place.

http://www.tek-tips.com/faqs.cfm?fid=855