I’ve spent quite a bit of time trying to figuring out why I couldn’t connect to a table without having update rights on it. My use case is the following one:
I’ve got a Countries and Addresses tables.
Countries entries aren’t supposed to be updated by anyone (almost). It’s a basic table to which many tables are linked to.
Anyone can create an Address entry and set a reference to a country by updating the entry and connecting the country.
Problem is, I need to put an “Update” access to everyone but with custom field settings that put every field to “Read”. So no update possible. (I understand that in the background the update access is there to allow the relationship fields to be updated I guess).
I don’t know, it didn’t feel natural.
Am I doing things the wrong way?