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.
