Forum Discussion

gazzo1967's avatar
gazzo1967
Icon for Helper III rankHelper III
2 years ago
Solved

RLS/Dynamic Filter Help needed

HI All Sample data Table One (Employee TEST data) NAME EMAIL LOCATION WATCH ROLE Andy Jones [email protected] A red Crew Paul Smith [email protected] B green Watch Dave Bro...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    2 years ago

    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.

gazzo1967's avatar
gazzo1967
Icon for Helper III rankHelper III
2 years ago

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 😁)

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
2 years ago

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.

  • gazzo1967's avatar
    gazzo1967
    Icon for Helper III rankHelper III
    2 years ago

    jdbuchanan71 
    Again thank you for your support 
    🙂
    Gary