Relationship and Union Query Problem.

[burrina]

Ok, I am trying to use a Unique bank account for each check register. I want to open my table TReg and be able to see all of the transactions for ONLY the Bank Account associated with it.
Each table/query is described under properties. My problem right now is I can't select a Bank Account for my check register because of my union query and it's one sided thingy! Can someone please take a look at my relationships and maybe the union query and advise? The Union query works fine like it is.It just prevents me from getting my end result.

[June7]

What are you using UNION query for? UNION queries are not editable.

The query design you show does not show TReg table nor the UNION query.

Don't understand the issue.

[burrina]

What I posted was a Union Query with the code.The query named QRegB has QRegA in it which uses the TReg table. If the query is not editable once it is made, then i either delete it, remake it or come up with something else.

[June7]

I still don't know your purpose for the UNION query. If it is not used in QRegB or QRegA, how does it relate to this issue?

Since you show BankID as PK in TBanks linking to RegID field in TReg, I presume RegID is FK field. TReg doesn't have a primary key?

Employees and TOthers don't show any relationship to TBanks and TReg.

[burrina]

This db was originally part of a much vaster complex db I wrote a long time ago. I am trying to remember what I did and how and add it back into this db. If you don't feel like fooling with this I understand, I am probably your worst thorn in your side. I have created 2 totally new and "Non" "Unionized" queries. Will see if I can make the check register work.