Code:
I basically need to create a form that multiple users can be in at one time.
* split the database to have a backend and then a front end for users.
Code:
Name – This needs to be a drop down list, and the list needs to be able to be edited with more people if needed.
Combo box data would be linked to the table for your "people" whom ever they may be. Then if you want users to have the ability to add people make a buttom somewhere thats a data entry form for this table.
Code:
When they complete the relevant boxes I would like the name, number and type of request to save in a file named with the date they choose and as more people input work on a certain day it slowly fills up with information.
have a table for the appointments/work whatever it is. This would then link to the "people" so... person 1 can be on several jobs.
To manage this data at a later stage you query it. eg. date = 08/04/2016
maybe some of my points are a bit vague to you but your question is vague. If you have any specific questions just ask.