I have created two subforms
fron two tables; tblPlaintiff and tblDefend
subforms are in the main form "FMCase"
all are connected (relationship) by the CaseNo one-to-many
problem:
after entering the case number in the FMCase, the subforms,
PlaintiffSub and DefendSub both show the just entered case number.
Now I am in the subform Plaintiff and enter a first name field and last name field, this generates the case number, first name and last name in the TBLplaintiff
When i enter a second name, this generates a second record with the same case number in the table.
How can i have one record for case number and then a list of all of the names listed in that case number instead of seperate records for EACH name?
fron two tables; tblPlaintiff and tblDefend
subforms are in the main form "FMCase"
all are connected (relationship) by the CaseNo one-to-many
problem:
after entering the case number in the FMCase, the subforms,
PlaintiffSub and DefendSub both show the just entered case number.
Now I am in the subform Plaintiff and enter a first name field and last name field, this generates the case number, first name and last name in the TBLplaintiff
When i enter a second name, this generates a second record with the same case number in the table.
How can i have one record for case number and then a list of all of the names listed in that case number instead of seperate records for EACH name?