Weird relationship doo dars

[BeanBob]

Hello, if anyone can work this out, I shall give you a virtual bar of chocolate! (Woo!)

Here's my plan:

1 Customer has many accounts, each account has many invoices.

The problem access is having, is it doesn't appear to be able to make a 1-m relationship between the accounts and the invoices.

Any ideas how to fix this?

Paul

 

[scriverb]

There are three tables here:
Table: Customers Fields: CustomerID
Table: Accounts Fields: Account# and CustomerID
Table: Invoices Fields: Invoice#, Account#, and CustomerID

The fields above would be the Primary Indexes for their respective tables.
The first one-to-many relationship would first be created between Custeomres/CustomerID and Accounts/CustomerID.
The second one-to-many relationship would be created between Accounts/Accounts#, CustomerID and Invoices/Account#, CustomerID.

Let me know if this helps.

Bob Scriver

 

[BeanBob]

Nope, that is what I currently have. The second relationship is going down as "Indeterminate"

Any other suggestions?

 

[scriverb]

BeanBob: I just created the relationships as we have discussed and I have a small database with just the tables and relationships. Send me an email and I attach it to you via return email. My email address is in my profile.

This relationship is valid.

Bob Scriver