June 14, 20169 yr Newbies Hi everyone, The problem I met is about record set is difference between the FM Pro 15 and it behaves at webdirect. Here is the scenario : Table : Contract, Salesperson, User Relationship: User <--[pk]----user_id----[fk]--> Salesperson Contract <-[fk]----sales_id----[pk]--> Salesperson Privilege set : [Manager] - For record, table "Contract" (view) is limited to Salesperson::dept = $$DEPT For layout, view access is allowed [Salesperson] - For record, table "Contract" (view) is limited to Salesperson::user_id = $$USER_ID For layout, view access is allowed Flow: 1) Once login-ed in, the script is triggered to load certain users' info. to global variables(e.g $$DEPT, $$USER_ID) by using the Get(Accountname) and table User 2) After entering the layout which load the contract data, records showed should be limited according to privilege set Problem is I could have the expected result at FM Pro 15 but not at webdirect with the same source. E.g With [manager] privilege set, (FM15) I could load the contract record within the whole department which assigned at table. (WD) No matched record With [salesperson] privilege set, (FM15) & (WD) I could load the salesperson corresponding contract. * I could only found out that no Salesperson info. could be read / related to the contract layout, when the privilege set is [manager].I would appreciated it if anyone could help.
Create an account or sign in to comment