I'm having a problem.
The subject involves 3 Tables
How I configured:
In Table_2 I configured a field as a checkbox, checked Requires search and Use Lookup table, filled in the Lookup Table fields with data from Table_1 (Table name, Link field and the 4 fields from the Display Fields)...
In Table_3, I configured a field as a checkbox, checked Requires search and Use Lookup table, filled in the Lookup Table fields with data from Table_2 (Table name, Link field and 3 fields from Display Fields).
Problem:
When loading the page / form, the configured checkbox displays all the data configured in the Lookup Table of Table_2 plus the data configured in the Lookup Table of Table_3.
I got around the situation by creating a custom field in Table_2 duplicating the desired field without configuring Lookup Table.
Can someone help me?