help with table/field joins

[cox]

I have 5 tables:
Link_Number
Customer_Number
Customer_Name
Customer_Address
actions

I have multiple customer numbers per link number, multiple customer names
per customer number, multiple customer addresses per customer name, and
multiple actions per customer address.

Here is how I am set up:

Link_number customer_number customer_name
customer_address pfr actions

Id id id
id id id

Link link
customer_number customer_name customer_address notes

customer_number customer_name
customer_number

My tables are joined by the field that is exactly the same

Link_number.link - customer_number.link
Customer_number.customer_number - customer_name.customer_number
Customer_name.customer_name - customer_address.customer.name
Customer_address.id - actions.id



Right now my problem is that I can only have 1 unique customer number in the
table, regardless of the link number. What am I doing wrong?




Thanks,
Bob W.

 

[Michael Cheng [MSFT]]

Hi cox,

Thanks for your post.

From your descriptions, I understood that you would like to have that
one-to-many relationship between the tables and keep unique for that key in
"many" relationship. Have I understood you? Correct me if I was wrong.

Based on my scope, you could use ValidationRule Property to make sure it is
unique via the expression like this: DLookup("CustomerID", "Customers",
"CustomerID = Forms!Customers!CustomerID") Is Null

Hope this helps and don't hesitate to let me know if you need further help.
We are always here to be of assistance!


Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center

 

[Michael Cheng [MSFT]]

Hi cox,

I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!


Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center