I have an organization of organizations; I have a table with each org’s details and another with each individual member’s details, and these are linked to each other. I want the members to have a self-service form for updating their info, or adding new info.
What I have in mind is that there would be a view of the org table where they could select their org, or add a new org. This would pre-fil the view with the existing details for that org, but they could change those details or add to them. There would also be a view of the members table where they could add/delete/change members.
I understand how to create a view of an existing table, but not sure how to pre-fill the info after the org is selected.