TableA Field holds one word "Red" or "Blue"? not "Burnt Sienna"
TableB Field holds one word "Ball" or "Cube" ? not "Oblate Speroid"
TableC Field will ALWAYS contain a word(s) from TableA Field AND OR TableB Field in that order?
Define worst case scenario is always a good idea - Sam Smth vs Lucinda Belle Von Neuman Jr Phd DDS
Thanks for the comments...
David: A & B do only hold one value with C always holding the combinations of A & B
The demo file by Phil may help with the last Checkboxes exampke kind of what I trying to do but instad of checkboxes I just want the protal to not show any records if all combinations have been used already (so dwindling but also removign them from the portal)....
Will have to look more deeply into whats going on in that demo file to understand more of what could be possible...