I am creating a shared database to record requests entered by a team of 30. I need to record the Order Number, Reviewer Name, Date, Action Type(Order Type), Client Name, and a comments box for each order entered.
When creating forms, Currently Reviewer Name and Date are auto-input so the reviewer will not have to enter this information. Client Name, Action Type are drop down boxes and Order Number is manual input. All are required inputs excepting the comments field.
Can 30 people add to one table all at the same time? Or is a more practical approach 30 tables with 30 forms and then linking the tables for reporting?