Jump to content

Three Database Relationship


Sam Laundon

This topic is 7585 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7585 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.