Select multiple rows from en embedded table

Hi everyone,

the tile speaks for itself but I will use my own database as an example.

I have a database that contains information about art objects. Under the heading 'Administration' I have embedded a table called 'Contacts'. Now for some art objects it is necessary to select more than one contact from the embedded 'Contacts' table. I can only select one.

Can someone help me out?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 2 wk ago
    • Reported - view

    You have two choices here:

    1) you can create another Contacts reference field, yes you can have multiple links to the same table. Then you can select a second Contact record. But what if you need a third or fourth?

    2) you can create a N:N (many to many) table that links art objects and Contacts. Now you can create 1 contact per record in art objects or create 20 contacts per record. This new table can just have two reference fields (one to Contacts and one to objects).

Like1 Follow
  • 2 wk agoLast active
  • 1Replies
  • 19Views
  • 2 Following