Hi
I'm building a Power Pages site (my second one) and I'm gradually understanding the quirks.
However, this one is perplexing.
I have a table that includes a lookup to another table.
In the data section (where you create Views & Forms) I can happily select and save an option in the lookup column.
However, when I open up the form in the web page to add/edit and click the search option to find an option I get a 'You don't have permissions to view these records'.
At this stage I'm keeping the permissions quite open (all options and roles added) and will reduce access in due course. Currently I can save/view/edit/delete entries but I can't pull through the lookup values into the Form to add/edit them. Additionally, when editing items where I've selected an option in the data section I get a 'Form could not be submitted due to appropriate permissions' error.
What permission do I need to set (and on what) to be able to pull the lookup options through and be able to save them?
Thanks in advance.
Typical, I've just figured it out.
For the table used as the LookUp you need to add a Table Permission to it with Read and Append selected with the same roles as the main table permission.
It now works.
oliver.rodrigues
16
Most Valuable Professional
Ă–E-05091504-0
6
JB-10040341-0
2