Three Database Relationship

[Sam Laundon]

Here is the problem:

I have three databases 1. Client Addresses, 2. Client Order and 3. Email Client.

When a client place an order it goes into the Client Order (Client ID is the relationship from Client Addresses to Client Order). When the order is completed they are notified by email through the Email Client database (CurrentRecId is the relationship between Client Order and Email Client).

The only way I have figured out how to bring the client's email address from Client Order into Email Client is with an email field lookup from Client Addresses to Client Order. When I have tried creating an email relationship between the Client Addresses and the Client Order, the contents of the field is not transferred to the Email Client.

Client Addresses (email address) ---> Client Order (email address lookup) ---> Email Client

Am I doing something wrong or is it not possible to do what I want to do here.

Thanks in advance for your help - Sam

[stanley]

Sam:

The problem you've encountered is that a relationship will not show data from other relationships. There are a few simple workarounds.

The easiest way to do this is to create a field in Client Order which will contain the email address - a calculation based on the already existing relationship will do it. Then, when you're moving information to the Email Client database from Client Order, you can take the data in the new email address field via that existing relationship.

-Stanley