Hi all
I've been staring at this for ages, so I thought I'd throw it open to the community. I'm sure I'm just missing something simple, but I'm if I can find it!
I'm trying to create a protocol that will allow a user to view a database as a table and select an entry to edit (see attached example). The last column of the table contains an edit icon which I want to connect to a work protocol that will display the record in an editable form. The user then makes their changes and submits to run an update query on the database. What I can't seem to work out is how to get the protocol link to pass the compoundID value to the work protocol which runs a select query to populate the update form (clear?).
I had looked at using an editable table which was great and easy, but I couldn't work out how to pick out the edits from the returned json string to then update the database - if someone can tell me how to do this it would great and save a lot of messing about with secondary forms.
I'd appreciate any help.
Thanks
Hassan