My question concerns two subforms on a main form. I am getting records that duplicate the record info on the first subform for each record entered on the second form. i.e.,
if an item is entered on the first subform and two items on the second subform, the records show the item on the first subform repeated with each entry on the second subform. Can anyone tell me if this might be a table relationship problem (both subforms are separate types of info for a single person's record on the main form) or if I may have the Child/Parent relationship set up incorrectly. Thanks for any insight you may have.
if an item is entered on the first subform and two items on the second subform, the records show the item on the first subform repeated with each entry on the second subform. Can anyone tell me if this might be a table relationship problem (both subforms are separate types of info for a single person's record on the main form) or if I may have the Child/Parent relationship set up incorrectly. Thanks for any insight you may have.