Related tables – show multiple values in form-field

  • Resolved erik2

    (@erik2)


    2 years, 10 months ago

    I’m using Advanced Content Types with custom tables:

    BOOKS
    PERSONS
    ROLES

    One “book” can have several “persons” with each a “role” (like author or illustrator etc). Also, one person can have several roles.

    I made an extra LINK_TABLE that holds the combination of person->role. It has 2 relation-fields: one to the PERSONS table and one to the ROLES table.

    Finally, in the BOOKS table I added a relation-field to the LINK_TABLE.

    All is good, except for one thing: when adding a book, the form holding the relation-field to the LINK_TABLE only shows the name of the person, therefore I do not know what the combination of person->role is that I am selecting (as one person can hold multiple roles).

    Is there a way to show two (concatenated) values in that relation-field, so that the combination person->role becomes clear? Or should I approach this matter in a different way?

    Thanks!

Viewing 1 replies (of 1 total)
  • Plugin Author Jory Hogeveen

    (@keraweb)

    Hi @erik2

    In this case I think it’s best to do it a little different when using the link table.
    You mentioned two separate link tabled if I’m correct, but this situation can be done in one.

    You can set the book, user and it’s roles in one single link:

    field 1: Book (single relationship)
    field 2: Person (single relationship)
    field 3: Roles (multiple relationship)

    You can then set the title for these link records to the format you want ??

    Cheers, Jory

Viewing 1 replies (of 1 total)
  • The topic ‘Related tables – show multiple values in form-field’ is closed to new replies.