Can someone help,
I have a main table in my db called Application, which has a primary key 'Application ID', which is an auto number. 19 other tables are connected to this main table by and ID field (primary key in the one-one tables) which is a number field. These tables either have one-many relationships or one-one relationships, with the table Application.
My problem is that i have set up a multi table query which is updatable, which is running a tabbed form, which includes four sub-forms.
When data is entered into this form i am unable to enter data into my sub forms , and the form does not appear to save, however the data DOES seem to be saving into some of the talbles, and the correct autonumber from the Application table is going into the ID field of some of the tables.
Also when i enter data into the first field in the form, i get an error message, saying 'this field is not updatable', but after i click 'ok', it lets me enter data into this field.
Any help would be greatly appreciated.
I have a main table in my db called Application, which has a primary key 'Application ID', which is an auto number. 19 other tables are connected to this main table by and ID field (primary key in the one-one tables) which is a number field. These tables either have one-many relationships or one-one relationships, with the table Application.
My problem is that i have set up a multi table query which is updatable, which is running a tabbed form, which includes four sub-forms.
When data is entered into this form i am unable to enter data into my sub forms , and the form does not appear to save, however the data DOES seem to be saving into some of the talbles, and the correct autonumber from the Application table is going into the ID field of some of the tables.
Also when i enter data into the first field in the form, i get an error message, saying 'this field is not updatable', but after i click 'ok', it lets me enter data into this field.
Any help would be greatly appreciated.
