I have a base that has a table for tags, a table with a list of clients, and a table with images
in the images table I have images, a lookup field for the tags from the tags table, and then a lookup field for client
client A’s red tagged images are image 1 and image 4
client B’s red tagged images are images 2 and 3
in the client tag sets base, I specify which tags belong to each client (tags can overlap)
client A: red, green
client B: yellow, orange, red
both client A and B have images tagged ‘red’
in the tags table, it shows each of the tags, the images containing each tag and the client tag sets
I’m having trouble figuring out how to create a grid view within the tags table that will show the images tagged ‘red’ but only if their client is client A. and then another grid view that shows images tagged ‘red’ but only if their client is client B.
Solved! Go to Solution.