I want to build a query that will search for a employee ID in one table and insert the data associated with the employee ID into another table then build a form to run the query. any ideas?
I want to build a query that will search for a employee ID in one table and insert the data associated with the employee ID into another table then build a form to run the query. any ideas?
create an append query. pull down your table to search in, in criteria add a param [Enter Search ID]
set the table to append the data