I have a Contracts table and a Cemetery Spaces table.
The contracts have a multivalued field that can associate it with multiple records in the Cemetery Spaces table.
Also, the Cemetery Spaces table's records may be associated with more than one contract, for example if someone purchases a lot but they die and then a family member purchases the memorial.
I would like to be able to select the applicable Cemetery Spaces in the multivalued field from the Contract form and have those multiple contract numbers appear in single records when I flip through records in the Cemetery Spaces form.
I'm having difficulty combining the Contract numbers when there is more than one contract associated with a Cemetery Space.
please see file: http://immergencehealth.com/downloads/Cemetery.zip
I have two contracts, "Contract 1001" associated with spaces A, B, C, and D, and the "Contract 1002" associated only with spaces A, B, and C.
When I flip through the individual records A, B, C, and D, I need for it to display that space A is associated with Contracts 1001, 1002--same with B, and C--and space D is associated with Contract 1001 only.