new access users first db

[sagey]

can anyone help me

i am trying to create a really simple db that at some point will run behind a website.

at the moment im having trouble with just designing it.

i want it so that the user would select a their company from a drop down menu, they would then enter a password.

they would then get a list of all the other users from that company.

the fields would be
i think
username | email address | location | personal notes

i dont have a problem sorting out the fields but what i do have a problem with is how to do a drop down list of the companies

there would only be one password for each company.

ive tried having the company name as a field in the db and then using the query wizard to return one company but am stuck

i guess my question boils down to two things.

1 how to add a drop down list of the companies
2 how to write a query so that it returns all the users that are under that company

if anyone can help an access beginner i would be very grateful

 

[shacket]

Let me get you started, but I want to encourage you to get a book on Access, read through the help files (which I think are excellent) and look over some tutorial websites to learn the basics. Forums such as these are really made for specific troubleshooting and not neccessarily for teaching entire concepts.

But to you questions...

1. How to add a drop down list of companies

You would create a table with your list of companies. (I would recommend using a Primary Key). On your form, click on a drop down box and then click to place it on the form. A wizard will come up asking where you want to get the information for the drop down box. Choose the table with your companies.

2. Create a query with all users for that company

You need to establish a table for users that is linked (through relationships) to the companies table. You would then create a query that includes the user name and company name, and type in the company you want in the criteria line.

I am assuming that a lot of the above looks like jibberish to you. I attached a VERY simple database for you to poke through. I hope this helps you get started!