I am having issues trying to create a query that will allow me to lookup information from one table, populate the data into a Form, then allow additional input into the Form and with the click of a button, post both the looked up and entered data into a different table than where the lookup was performed.
I am looking up name and address information from a table called Roster by an employee ID [EID] and populating part of a Form when it opens. Then I need to enter shipping information into the bottom half of the Form and then save all of the data (including the address info) into a table called [WAH_Shipping_Detail]. I can get the data to populate for the name and address. I've tried to join the two tables in a query, but when I do that I get a list of all of the records that reside in the WAH table. I am unable to input any information or edit what is pulled up.
I have spent 4 days on this and just can't get the right combination to make it work. Oh yeah, I'm not a whiz with SQL either.
If anyone can assist me, I would GREATLY APPRECIATE it!
Thank you.