Issue with table

[mari_hitz]

Hi everybody,

Hope you can help me out in this. I have a database created for HR purposes where I have all the team members of my team. I created several tables with personal information, vacations, leave of absences and study days.
I have created a form that contains several tabs and each one of them contains this tables showing this information for a particular person. I have created also a query for the vacations information whith several calculations. I put the query in one of the tabs and no matter which person I see the information, always shows me the information for all the persons instead of the information of the person I am viewing at the time.
I have tried to put criteria on the query, however when I go to this tab where the query is, it asks me for the last name and first name which where the criteria I put.

I have created relationship with all the tables and queries

My question is: how can I make to view the information only of the person I want instead of the whole list of people.

Thanks!

 

[jdraw]

Please show us your tables and relationships in jpg format.

 

[mari_hitz]

Hi JDraw!

Thanks for your reply! I am uploading my database here, is kind of a mess, I am still trying to figure out somethings.

The form in which I am having issues is "Contact Details". Again, I am sorry for my database, I am still new at this and I do not have much imagination, so I am doing my best

Thanks again!!!

 

[jdraw]

I have access 2003 so can not use an accdb formatted file.
If you post a database file, please post in mdb format.

A picture of your tables and relationships would be sufficient at this time.

 

[mari_hitz]

JDraw, I am sorry for posting the database wrongly.

Here you can find the picture.

Thanks again por all your help

 

[jdraw]

Why are there several "contact" tables?

Recommend you use a naming convention that does not allow spaces or special characters in field and object names. Use only alphanumeric and "_"

I'm not following the model. In Review table wouldn't you have a ReviewDate field?

You should research Normalization. It will help you with table design and structures. You do not need to record/store the same LastName and FirstName in different tables. You may wish to research --- MS Access autonumbers.


Every table should have a Primary Key.

Here is a data model that may help with some of the tables.
http://www.databaseanswers.org/data_models/employees_leave_record_keeping/index.htm

Good luck with your project.