Forum Discussion
gazzo1967
Helper III
Helper IIIRLS/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...
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.
gazzo1967Helper III
Helper IIIjdbuchanan71
Sorry will try to better explain my objective
When a user 'Peter Green' logs in I would like him to only see from SA table
Anyone who is at the same [location] and [job_watch] (can i add data from either table as additional columns? I havent added all the columns on here)
Sorry I have a much clearer head today!
Expected outcome
| full_name | email_address | location | job_watch | role_basic | assessment |
| Mike New | [email protected] | B | green | FF | 78 |
| Pete Green | [email protected] | B | green | FF | 76 |
When a user 'Andy Jones' logs in I would like him to only see from SA table
| full_name | email_address | location | job_watch | role_basic | assessment |
| Andy Jones | [email protected] | A | red | Crew | 90 |
| Mike White | [email protected] | A | red | FF | 69 |
SA Table
| full_name | email_address | location | job_watch | role_basic | assessment |
| Andy Jones | [email protected] | A | red | Crew | 90 |
| Paul Smith | [email protected] | B | white | Watch | 79 |
| Dave Brown | [email protected] | C | white | Crew | 89 |
| Rich Davis | [email protected] | D | blue | Crew | 76 |
| Steve Blue | [email protected] | D | blue | FF | 80 |
| Mike New | [email protected] | B | green | FF | 78 |
| Pete Green | [email protected] | B | green | FF | 76 |
| Mike White | [email protected] | A | red | FF | 69 |
| Peter Long | [email protected] | B | blue | FF | 69 |
| Mitchell Bow | [email protected] | B | red | FF | 69 |
WMFSED table
| NAME | WORK_EMAIL | JOB_LOCATION | JOB_WATCH | Role_Basic |
| Andy Jones | [email protected] | A | red | Crew |
| Paul Smith | [email protected] | B | white | Watch |
| Dave Brown | [email protected] | C | white | Crew |
| Rich Davis | [email protected] | D | blue | Crew |
| Steve Blue | [email protected] | D | blue | FF |
| Mike New | [email protected] | B | green | FF |
| Pete Green | [email protected] | B | green | FF |
| Mike White | [email protected] | A | red | FF |
| Peter Long | [email protected] | B | blue | FF |
| Mitchell Bow | [email protected] | B | red | FF |