I suggest you add the ability to lookup the data in a single record from a form, for any user who is logged in and has access to that record’s data. Then, it would prefill into the other fields of the form and can be reviewed, edited etc.
For instance, if I have a table of users, I could use the first field to search for the user I want, and then his/her phone number, address etc. would pop into the other fields, and I could review and change if necessary.
... View more