Customers table (show few only)
id,name,groupid
1,“Cust01”,“1,2”
2,“Cust02”,“1,3”
3,“Cust03”,“2,4”
4,“Cust04”,“1,2,3”
…Groups table (show few only)
id,code,customerid
1,“GroupA”,“1,2,4”
2,“GroupB”,“1,3,4”
3,“GroupC”,“2,4”
4,“GroupD”,“3”
…When users that assigned with Group (A & B), (A & D) or (B & C) , he can select customer 1,2,3 & 4.
When assign with Group (C & D), only Customer 2,3 and 4 can be selected.
I already created a view for this (view file name customer2)But what I want is, above view file is for Operation staff (CurrentUserLevel() == 9) use only.
For Admin / Management level (CurrentUserLevel() < 9) people, is allowed to select any Customer in customers file (no restriction)My Question is, can we change the Table Name in Lookup Table → Table Name dynamically?TIA
See Example 3 under Lookup_Selecting server event from the documentation.
Thank,I used the Example 5 syntax. & I moved the view statement into the ExecuteRows() and no need view table now. Work as expected.