I have created a single table and form based on a spreadsheet. This will be used by people to provide information for review/approval. The approval stage requires the approver to view the information and to complete a new form which is linked to the first form.
Should I create a second table for the approver and link the two tables? Or keep in one table and hide the approver section from the submitter ? If the latter how do I hide the approver section, can this be achieved with security roles?

Report
All responses (
Answers (