Hi I believe I bring a complex topic, when Santiago explained about Dependant Dropdown he said “While most app creators will never need to express something this complicated,”
I believe that I have something a bit more complicated…
I have a table to capture Orders
This table have a column that Ref to a table of Clients by Client ID
it also has another column that Ref to a table of Jobs by Job ID that depend on the first
The Jobs table have both columns but with no usable names for the user, just Unique ID (Client ID and Jobs ID). The question is can I make 2 dependant dropdown by Unique ID but show the correspondent label that is in a different table?