I am very new to Access, and learning a lot on the way. I have googled for hours to find a solution to this and am obviously not asking the question the right way.
I'm creating a database for client services which involves a many to many relationship.
While clients are registered individually, the visits are recorded on a family basis.
I've created a junction table that links clients to families, and families to visits (i've attached an image of the relationships below).
I understand how to make this work when there are records in both tables, but for new clients there won't be records in the Visits table.
What I think will work is if i create a registrations form that includes a Family ID number (that can be used later in the junction table), but which is not linked to the junction table, then i create a Visits form that also creates the input for the junction table (using a look up, i presume, to get the family info from the registrations form). Does that make sense?
How would I do that in practical terms?
I'm creating a database for client services which involves a many to many relationship.
While clients are registered individually, the visits are recorded on a family basis.
I've created a junction table that links clients to families, and families to visits (i've attached an image of the relationships below).
I understand how to make this work when there are records in both tables, but for new clients there won't be records in the Visits table.
What I think will work is if i create a registrations form that includes a Family ID number (that can be used later in the junction table), but which is not linked to the junction table, then i create a Visits form that also creates the input for the junction table (using a look up, i presume, to get the family info from the registrations form). Does that make sense?
How would I do that in practical terms?