Two records on one form? Seeking Ideas

[d9pierce1]

Hi all,
I have a person form with Person and Spouse as one record. I would like to make that two records but keep on form the Person and the Spouse if that is possible.
I attached current form and table screen shots. I just not sure how to make the Person one record and the Spouse one record and have them on the same page?


Does anyone have any ideas on this please. Or even maybe how to link them as separate records. Just cant picture how this would look or work.
Thanks to all
Dave

[orange]

Dave,

Just a thought for consideration. If the person table contained individuals, you could have a field in the record that identifies the spouse/partner id. Suggest a field in the table spousePartnerId Long integer where the spouse/partner id is recorded. This would record individual persons and "self join" with spouse/partner for related processing.
You know your details and requirements better than readers, but this is an approach you may want to investigate. I have used this in the past when dealing with dog pedigree --similar concept.
Good luck.

[d9pierce1]

Thanks Orange,
I believe something like that would work for this. I hadnt thought of that so thank you. I have been at a loss since i built this table/form
as one does need specific info for each person/spouse but they need to share a relationship, as well as address, some phone numbers so I will
work on this and see what i can come up with... The way i did it just hasnt set well with me since so time to change it up!
Thanks again,
Dave