0

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

null
    • Choices_Software_Dean
    • 3 yrs ago
    • Reported - view

    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?

    • soloojos
    • Michael_Thompson
    • 3 yrs ago
    • Reported - view

    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.

    • Mconneen
    • 3 yrs ago
    • Reported - view

    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.

    dataModel

    Here is the main client form..

    Form1

    and creating an address

    form2

    • soloojos
    • Michael_Thompson
    • 3 yrs ago
    • Reported - view

    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.

Login to reply

Content aside

  • 3 yrs agoLast active
  • 4Replies
  • 593Views