How to create a form that adds data to existing records, rather than creating a new record?
For further context; in my table, each record is a Client and their contact details are noted. I want to use a form to add their email subscription status (single select field) without doing it through a filtered grid view.
I tried setting up a form in the Client table but it added a new Client record and didn't allow me to select an existing client. Any help would be much appreciated.
