Hi Dave
If it were me, this is what I would do.
1 Create a users table, four fields
User ID, autonumber
User first name
user second name
user password (password input mask)
2 Add a user field to my company records table (number field)
3 Create a one to many relationship between users (1) and company records (many)
4 Run an update query on my company records table to allocate user IDs to records: select record numbers 1 - 500 update User ID field to user number 1 and so on. You'll need to do them one at a time (batches of users - not company records - phew!).
5 Create an unbound form (dialog box). Using the combo box wizard create a combo box that lists all the user names (it will have to fields: user ID (which is hidden) and user name (you could join the first and surnames into one field in the combo box query) which the user uses to select their own name)
6 create an unbound text field and set the input mask to Password.
7 Create a command button for OK. Attached to the command button, have a DLookup that verifies that the password matches that user (we can work on that later)
8 If the password matches the user's ID in the user base table, open the main form showing records that match the user ID. If it doesn't get them to try again (again we can work on that).
There should be stuff above which you can handle yourself and then when it gets to the coding bit we can work on that further if you need a hand.
Hope that all makes sense. If you are really stuck I am more than happy to have a look at your database if you can zip it and email it to me.
I definitely think this is the way to go. You need to establish a relationship between users and records for this to work.
Now I can go to bed!
Dawn
[This message has been edited by D B Lawson (edited 01-28-2002).]
[This message has been edited by D B Lawson (edited 01-28-2002).]
