Need to create default sign in

This shouldn't be hard to solve

The Events and Jobs database has an admin set with ability to set other users after admin is set

How do I get a database set to other users like the movie for security settings in the tutorials section

Any help would be apreciated

It's hard to understand what exactly your question is, this is probably why you not getting any replies. Try to rephrase it.

Sorry for the reply, I'm recovering from a stroke.

I want to create a database like the Events database

I have my main table (part number data) and I create an empty table for the user data (id field, user name, and password) I then create an admin user. When I try it, it uses the admin user but when I try to create another user it posts a duplicate key error on the primary key.

I want to create a table like the Events database with users for admin, managers, and users but I am unable.
Can you help?

The error message you getting means you trying to insert a duplicate value into a field that won't allow that i.e. primary key ID field.
My guess is that you either use Advanced Security option or Master-Details and one of these features is not setup properly.