Hi,
I have created 2 tables - tableA and tableB.
For tableA, "After table initialized", I have written a code to allow userA only able to view the records that has his name appeared under a column.
$query->addWhere("columnA='".$_SESSION["userA"]."'");
For tableB, I have a column which I used "Lookup Wizard" and link field is based on tableA.
My expected outcome:
- I need to make userA only able to view his own record in tableA => this is ok
- For tableB, the column which link to tableA, I need to show all the records in the drop-down list. My current issue is that the drop-down list only appear what he can see in tableA. Can anyone advise on this?
Thanks.