F
Flora
Hi,
I have a checklist table which has many fields. This table relates with the main table by the caseNo field. I created a form with the datasource from main table, and this main form should have a subform with data source comes from the checklist table. Since the Checklist table has many fields, it is too long for one subform. I divide this subform into two subforms partA and partB (put them in Tab, two pages) each has half of the datasource from checklist table. These two subforms related with the main form using same caseNo. My problem is that when I fill out the subforms partA and partB, and try to save it, it won't allow me to do so, and the pop up window says "it generates duplicate value in index, or primary key". Actually there are not duplicates. What it allows is to fill out partA, close the form, then open the form, continue to fill out partB. Anybody know how to update the subforms partA and partB together? The detail is as below
Main table: pk: caseNo,
checklist table: pk: caseNo,
Main form: pk: caseNo,
partA subform: pk: caseNo,
partB subform: pk: caseNo,
partA and partB are based on Checklist table. partA has first half fields of Checklist table, partB has second half fields of Checklist table.
Thanks in Advance!
Flora
I have a checklist table which has many fields. This table relates with the main table by the caseNo field. I created a form with the datasource from main table, and this main form should have a subform with data source comes from the checklist table. Since the Checklist table has many fields, it is too long for one subform. I divide this subform into two subforms partA and partB (put them in Tab, two pages) each has half of the datasource from checklist table. These two subforms related with the main form using same caseNo. My problem is that when I fill out the subforms partA and partB, and try to save it, it won't allow me to do so, and the pop up window says "it generates duplicate value in index, or primary key". Actually there are not duplicates. What it allows is to fill out partA, close the form, then open the form, continue to fill out partB. Anybody know how to update the subforms partA and partB together? The detail is as below
Main table: pk: caseNo,
checklist table: pk: caseNo,
Main form: pk: caseNo,
partA subform: pk: caseNo,
partB subform: pk: caseNo,
partA and partB are based on Checklist table. partA has first half fields of Checklist table, partB has second half fields of Checklist table.
Thanks in Advance!
Flora