Hello All,
I have two tables: 'Table A' and 'Table B'
Also i have two security Roles. 'Security Role 1' gives full access to 'Table A' and 'Security Role 2' gives full access to 'Table B'.
I have created a lookup column in 'Table B' with a relation to 'Table A'.
I have placed the lookup field on the form in a model driven app. When i type something in this lookup field, related records from 'Table A' are shown. If i select any record from lookup, related data will be fetched from the 'Table A' and a java script populates these data into other fields on the form.
When i am opening the application in 'Play' mode using the account i used to develop, lookup field is working fine.
But when other user try to login and access the form, the lookup column is locked(read only).
I have a lot of dependency on this lookup field downstream.
I tried to provide Append permission. But that didn't help.
Please could anyone help me on this.
Thanks in advance.
