Happy 4th of July.
I have a table called Rescue Organizations and an occurance called Active Rescues. I have created a value list that filters out in-active rescue organizations. It will work on one layout, but not on another.
So the quick question I have is this.... Do the value lists (when using 2 tables to show only a subset of records) work based on relationship to the layout (table occurance) they are used on? The underlying table I am trying to use this on is not related to either of the other tables and I am suspecting that this is why I am getting the results I am getting, but wanted to get confirmation from you folks.
I can give screenshots or DB layout info if needed.