Announcement

Collapse
No announcement yet.

Search (filter) on N-N relationship

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Search (filter) on N-N relationship

    Hi all,

    I'm having trouble filtering a table using an N-N relationship and then charting it from a grid. I either return duplicate records into the select box in the search form, or duplicate records into the grid. Has anyone done this successfully? How is it done?

    See below - I want to be able to display all contacts in a grid, and filter using city.

    eg>

    contact
    - id
    - name
    - address
    - city

    contact_has_city
    - id_contact
    - id_city

    city
    - id
    - name

  • #2
    Hello,

    Please contact our support regarding your question. Our chat is active on workdays from 8:00am to 6:00pm, and our ticket system is always available.

    regards
    Bernhard Bernsmann

    Comment

    Working...
    X