Possible Query Quandary

[JSimoncelli]

Hi All,
I may/may not have an issue, let me explain. I have two a table’s tblCMAS and tblOrganization. The tblOrganization table has a list of organizations and is the one side of the relationship. The tblCMAS table has three fields that are linked by the relationship and pull data (OrgID as FK) from the tblOrganization.
When I create a query using the tblCMAS to populate the query no problem I get correct data as a return. I then use the “Show Table” button from Query Setup to drop in the tblOrganization table with the intent of adding the Org field from that table. Even before I do anything by simply dropping the table in when I run the query there is data displayed…
So at this point I must assume I am breaking some big Query rule or something, can anyone point out the error of my way..
See Attached of the Query
John

 

[jdraw]

Add the organization table 3 times.
Each table will get a suffix _1 _2 etc.

Since you are using the Organization for different "things" you need to link three different Org tables. - 1 for each usage.

 

[JSimoncelli]

Thanks for the quick reply,
The tables are linked that way in the relationship Tab, but when I try to drop the tblOrganization table in I get what you see in the attachment and the results of the query is no data. I tried dropping tow additional tblOganization tables with no change.
John

 

[JSimoncelli]

If it helps attached is my current Relationship screen. You can see i have the tblOrganizatio and the _1 and _2.

John

 

[JSimoncelli]

Thanks Pat,

I was able to do as you sugjested, i did end up making select querys for the problem children on my form.

I am using Acess 2007 and it does seem to be buggy at times...

Thanks again

John