Hi, I tried asking this before but, I wasn't descriptive enough.
I have several tables:
Main Table (primary key is RecNo.) includes common info to all tables (ie. company name, coordinator)
Sched1 Table (primary key is Sched1ID) includes a field for RecNo.
Sched2 Table, Sched3 Table....
I also have several forms:
ie. Sched1 Form (query of Main Table and Sched1 Table) The Sched1 Table is in a subform. (some have more than 1 subform and in one case that is coming from 3 separate tables - the rest are all coming from the same table)
Originally I had the forms/subforms connected directly to the tables (not through queries)and when you entered the info in the forms, all the tables would update, including the RecNo in each table. The problem was that I was having major printing problems (duplicate pages) so, someone here advised me that I really should have created the forms from queries.
I set up a query for each form and included the RecNo. the main table. Now all the records that were previously there print perfectly. The problem is that I cannot add new records. It will allow me to create a new record in all the forms that only include the main table and one other one but, all the checkboxes are now greyed out and if I try to enter a check I get an error saying "You can't assign a value to this object" (if I click OK, it will fill in a check though). Then when I try to close the form, it says my changes were unsuccessful because they would create duplicate values in the index, primary key or relationship. If I check back in the table (ie. Sched1) a new record has been created but the RecNo. which ties back into the Main Table is blank. I have checked the relationships and all my tables are still showing as related by RecNo.
My other problem is that the one form that includes the Main Table and 3 other tables will not work with a query. I set the query up but, in the form it says too many fields defined (close to 300).
Any ideas would be appreciated.
I have several tables:
Main Table (primary key is RecNo.) includes common info to all tables (ie. company name, coordinator)
Sched1 Table (primary key is Sched1ID) includes a field for RecNo.
Sched2 Table, Sched3 Table....
I also have several forms:
ie. Sched1 Form (query of Main Table and Sched1 Table) The Sched1 Table is in a subform. (some have more than 1 subform and in one case that is coming from 3 separate tables - the rest are all coming from the same table)
Originally I had the forms/subforms connected directly to the tables (not through queries)and when you entered the info in the forms, all the tables would update, including the RecNo in each table. The problem was that I was having major printing problems (duplicate pages) so, someone here advised me that I really should have created the forms from queries.
I set up a query for each form and included the RecNo. the main table. Now all the records that were previously there print perfectly. The problem is that I cannot add new records. It will allow me to create a new record in all the forms that only include the main table and one other one but, all the checkboxes are now greyed out and if I try to enter a check I get an error saying "You can't assign a value to this object" (if I click OK, it will fill in a check though). Then when I try to close the form, it says my changes were unsuccessful because they would create duplicate values in the index, primary key or relationship. If I check back in the table (ie. Sched1) a new record has been created but the RecNo. which ties back into the Main Table is blank. I have checked the relationships and all my tables are still showing as related by RecNo.
My other problem is that the one form that includes the Main Table and 3 other tables will not work with a query. I set the query up but, in the form it says too many fields defined (close to 300).
Any ideas would be appreciated.
