Help Questionnaire
Describe the problem
I have a DB with 2 tables:
- events
- dances
1 event has many dances
1 dance has many events
Both tables have a “link to table” column for the other one. This allows adding/removing events to dances in the dances table, and vice versa. I can also click an element in the “link to table” column to open a detailed view (form) of the element. For instance, looking at a dance record, I can click on an event listed in the “link to table” column, and see the event details ; then from the event details, I can click on a listed dance there and see the dance details; etc. It’s an extremely convenient workflow.
Now I want to make this available publicly, but read-only. I have created a public url to “public” grid views of either table. This allows access to the respective tables. But unfortunately, it does not provide the ability to click on an element in the “link to table” column to open its details (understandably I assume since it would require further access to some “public” view for the element).
Now my question is: how can I emulate that i.e. create public, read-only access, to both tables that also allows drilling down into the “link to table” columns as described above? (it’s perfect if I can use the same non-hidden columns in the form view as those in my publicly accessible grid views)
