Forum Discussion
RLS/Dynamic Filter Help needed
You don't have the two table connected together do you? There is no need for a relationship between the two tables. That is the only thing I can think of that might cause the problem.
You don't have the two table connected together do you? There is no need for a relationship between the two tables. That is the only thing I can think of that might cause the problem.
jdbuchanan71
Thank you soo much for your patience and support 🙂
Yep it was the relationship.
Just for future reference can a third table ie SA2 be introduced (Just a question 😁)
Certainly. If the new table is linked below the SA Table (one to many from SA to SA2) then the filter you have on SA will get applied. If it is separate from SA then you would just add another filter to the new table in the same role.
jdbuchanan71
Again thank you for your support
🙂
Gary