I have a form that has several pages.
I use these forms to add data to three related tables.
I have created a SQL Query that links the tables togeather as the record source for the form.
The relationships of the three tables are one to many and then one to many.
The idea is that I have one main "batch", or production run that has many records, these records also have many records!
In the first page of the form I create this production run auto number, plus date, operator data etc.
In the second page I add the individual record data for each product we make including description info and then add the tally record information into a subform.
The problem I have is that once I create a new main record in the first form and then open the second page I can't add any data.
Any ideas?
Would it be OK to post the database?
Thanks
JG
I use these forms to add data to three related tables.
I have created a SQL Query that links the tables togeather as the record source for the form.
The relationships of the three tables are one to many and then one to many.
The idea is that I have one main "batch", or production run that has many records, these records also have many records!
In the first page of the form I create this production run auto number, plus date, operator data etc.
In the second page I add the individual record data for each product we make including description info and then add the tally record information into a subform.
The problem I have is that once I create a new main record in the first form and then open the second page I can't add any data.
Any ideas?
Would it be OK to post the database?
Thanks
JG
Last edited:
