Associate multiple subtable entries with one main table entry
I have a table "Clients" that holds a subtable "Addresses". I want to associate two address entries with each client. One will be a billing address and one a shipping address. The address entries each have a "type" of either Bill or Ship. I can't seem to find a good way to do this. Ideas? Thanks
4 replies
-
It sounds like you already have the relationship set up. What happens when you attempt to add a second Address for a client? What is not happening that you want to happen?
-
The fields lock up and it is very difficult to edit them. I am working with it again today and bringing a fresh look at it.
-
Not sure what you mean by "the fields lock up". What platform are you on? Web, Mac, iPad, ??
Here is the data model showing the composit relationship.
Here is the main client form..
and creating an address
-
I have no problem with the view as you show in the Clients table above. I am trying to assign those two values (Billing/Shipping) truncated in the Clients spreadsheet view so that I can have a quick overview of the client including their address information. That has broken down for me so far and, I am beginning to think is something I can do. Thanks for your reply.
Content aside
- 4 yrs agoLast active
- 4Replies
- 593Views