Tables

[joey345]

Hey everyone, new here...

I used to have a good understanding of Microsoft access but I haven't used it in near on 7 years and now I am at a complete loss how to deal with what I need to do.

I have a large table of contacts with detailed information on our members.

What I need to do is create a side (table? or box?) basically a menu with the country names linked in from the main table listed that then when you click on one country takes you to to all of the people from say Germany.

While a query is fine to do this individually, I need it to be streamlined upon entering the database. Any help would be deeply appreciated.

Many thanks

 

[rzw0wr]

Sounds like you need a refresher on tables.
Take a look at this.

http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html

Dale

 

[joey345]

Thanks Dale, this has helped.

Would you know how to create a menu - with the countries as options - that once clicked takes you directly to the individual records of that country?

Many thanks

Jo

 

[JHB]

I would use a combo box for that, instead of a menu.

 

[rzw0wr]

Sure do.
can you upload the database.

I can show you better than type it out.

Dale

 

[joey345]

Sorry Dale. There is no way I can upload it.

 

[rzw0wr]

Joey,
Take a look at the attached.
Are we getting close?

View attachment Database3.zip

Dale