Here is a draft data model that may be helpful.
Moderator
Windows 10 
Access 2010 32bit
Here is a draft data model that may be helpful.
Moderator
Windows 10 Access 2010 32bit
For some reason I can't get to post 16, so will try to repeat it here???
Update: Now I get 16 and 17????
I created a draft data model based on your latest description.
Last edited by orange; 08-25-2017 at 06:40 PM. Reason: could not get to post 16 from page 1???
Can relationships be defined only in each query, not in the Relationships window?
Explicit Relationships and Implicit Relationships
Too Many Relationships
Posting Permissions
Reply With Quote