Hi all,
I am new to the site, and would be considered more of the Newb status when it comes to Access. Please bare with me if I don't have all the verbiage down.
I seem to be having an issue with a particular situation within a few work databases I'm creating. To be specific of the issue, when ever I have a M:M relationship that requires a junction table, my queries will not populate and my subforms will not interact.
To add some context, I have a tabbed form containing subforms for data entry, of which, there are 3 1:M relationships with one having an additional M:M relationship. In particular, the M:M relationship consists of
the tables, "EstablishmentT", "EstablishmentOwnerT", and "OwnerInfoT". The junction table is the EstablishmentOnwer containing 2 FK's linked to each of the adjacent tables PK's. Both the tables EstablishmentT and OwnerInfoT have Autonumber PK's with the junction table having long interger number FK's.
The query that I setup relating the 3 tables is Estab_OwnerSubQuery and is setup with the default inner joins. When I run the query as is, it doesn't populate. I've tried creating various forms, but ultimately came down to the query not working. For my sanity, I cannot figure out what is wrong, and would really appreciate some help on the issue. I have a feeling that I'm missing something within the 3 tables relationships or in the query design.
As my main goal, I want to be able to enter the data through the main tabbed form.
Any help would be appreciated. If I'm not clear enough, please bare with me.
I have attached my database for your eyes.