Link or join tables
Posted: 2015-10-06 20:27
Hello all
I am new and I did some power searching on join and link in relation to the advanced filters. I did not really see a quick and simple way to join tables together in the way I envisioned. Example I want to use the advance filters and be able to use fields from different tables. See below
Table 1 column - dog
Table 2 column - food
Table 3 column - Toys
Advance filter
Filtered field comparison operator comparison value
filter 01 dog = poodle
filter 02 food = kibble
filter 03 toys = bone
Based on these fields in different tables I want the data to be displayed. How do I do this? Would this require some modification in the code or did I over look something? Thanks for your help.
I am new and I did some power searching on join and link in relation to the advanced filters. I did not really see a quick and simple way to join tables together in the way I envisioned. Example I want to use the advance filters and be able to use fields from different tables. See below
Table 1 column - dog
Table 2 column - food
Table 3 column - Toys
Advance filter
Filtered field comparison operator comparison value
filter 01 dog = poodle
filter 02 food = kibble
filter 03 toys = bone
Based on these fields in different tables I want the data to be displayed. How do I do this? Would this require some modification in the code or did I over look something? Thanks for your help.