Unsual error when I create a form using record insertion wizard

[vcujackson]

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

 

[lebisol]

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