Linking Three Tables

[LeBaron via AccessMonster.com]

Im going to try to explain this the best i can, since im an intermediate with
Access. I have 3 tables, my main table "Client", then i have the "Treasury"
table and "Process" table. Now they have their own primary key as 'ClientID',
'TreasuryID', and 'ProcessID' along with other names in the table. I made a
'ClientID' in both the 'Treasury' table and 'Process' table (one-to-one
relationship). So now i have all 3 tables linked together in the
relationship screen. Now my problem is, i can see the 'ClientID' autonumber
in of course the 'Client' table since its the main one, i see the number
generated from the Client table in the 'Process' table, but i dont see it in
the 'Treasury' table. and because of this, my form that i have linked to the
table/query, won't give me the results i need, but the 'Process' table does.
Now where am i going wrong here? Please help me before i start pulling out
the last little bit of hair on my head left )

 

[Beetle]

My first question would be *why* do you have these relationships set up
as one-to-one? Is a given Client only allowed to have *one* record in the
Treasury table and *one* record in the Process table? If that is the case
then why is the Treasury and Proccess data in separate tables?

One-to-one relationships are sometimes used incorrectly. As resident
MVP Jeff Boyce likes to say, you have described *how* you want to do
something but not much about *why* you want to do it that way. If you
can provide some more details about the *why*, someone may be able
to offer you some advice.

 

[LeBaron via AccessMonster.com]

thnaks i took your advice and manage to get it to work.

My first question would be *why* do you have these relationships set up
as one-to-one? Is a given Client only allowed to have *one* record in the
Treasury table and *one* record in the Process table? If that is the case
then why is the Treasury and Proccess data in separate tables?

One-to-one relationships are sometimes used incorrectly. As resident
MVP Jeff Boyce likes to say, you have described *how* you want to do
something but not much about *why* you want to do it that way. If you
can provide some more details about the *why*, someone may be able
to offer you some advice.

Im going to try to explain this the best i can, since im an intermediate with
Access. I have 3 tables, my main table "Client", then i have the "Treasury"

[quoted text clipped - 9 lines]

Now where am i going wrong here? Please help me before i start pulling out
the last little bit of hair on my head left )