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