How do you create something like this?

[hbrems]

Hi,

people randomly ask me to install software on their PC's. Instead I'd like them to be able to fill in this form (see attachment) so all information is stored in a database.

The fldsystems field is pulled from a table. How would I create the 'required' field so that multiple users can access this form at the same time.

Any ideas?

 

[agehoops]

Theoretically you should just need to split the database into a front end back end setup so many users can access it at once.

If you create a copy of the database, then in the front end, delete all the tables and only keep queries and forms and reports and such, and in the back end copy, delete everything except the tables. Then on the front end, and linked tables to the back end file, then get each user to run the front end from their machine which is linked to the back end.