Unanswered: I wanna link a form with multiple tables
this is kinda urgent what i am trying to do is that i want to link a combo to a text box where the text box selects the right designation of the employee from the employees table depending on the name of the employee that has been chosen in the combo box...both these fields belong to different tables and are to be stored in a new table that is designation, along with some new fields that have been entered by the employee in the form.
create a query that contains all the tables and fields you need. make sure you have key fields that will link all tables to avoid multiple rows of each record. now select the query instead of a table in your option field.