How to build joins in the list (fabrik) using multiple tables

Barcellos

Ana Barcellos
Consider the following table just like the old one in this other post where it was a unique table with all data and a repeat table (table 1 attached).
I divided the table in other several tables using id as foreign key, as attached (table 2).

When I create a list with tb-data-origin and a simple join to tb-data-repeat-destination and with all filters enabled, the values within the filters appears duplicated and the resulting search is wrong.

Using tb-data-1 e tb-data-repeat-1, how do I build the joins so the filters will not appear with duplicated values?
 

Attachments

  • table 1.JPG
    table 1.JPG
    58.8 KB · Views: 431
  • table 2.JPG
    table 2.JPG
    93.7 KB · Views: 435
More about our tables... (attached)

Since I have more than one unit in each city, I'm getting repeated results in the city/state/section's filter.
 

Attachments

  • DuvidaJoins_Fabrik2.PNG
    DuvidaJoins_Fabrik2.PNG
    64.8 KB · Views: 448
We are in need of some funding.
More details.

Thank you.

Members online

No members online now.
Back
Top