I used record insertion wizard from a table employee.  I created three recordsets  rs_employee, rs_Supervisor and rs_Title.  There are three tables, Employee, Supervisor and Title.  I link the three tables by name, not by a primary key.  What happens is when I test the form and click the insert button I get the following error. Microsoft error, must be an updateable query.  I find that odd.  I am thinking the problem rests with the fact I do not have primary and secondary key relationship between the main table Employee and the the Supervisor and Title table. Any ideas

you can test by inserting a records though the DB and see if it works. yes, relationships should be in place to start of.
you also need to 'inset into multiple tables' http://www.drdev.net/article01.asp#INSERT