Database Design - Need Help Urgently!!

M

mylittlevoices

Joined
Feb 28, 2008
Messages
2
Reaction score
0
Hi all,

I have created 4 tables: Tbl_Employees, Tbl_Categories, Tbl_Locations, Tbl_Sessions.

Details of each table as follows:
Tbl_Employees
EmpID [Primary Key]
EmpName
Div
RptMgr
Ext
Email
HireDate
CategoryID [Values from Tbl_Categories - using Lookup Wizard]
InitialHire
HireRemarks
LocationID [Values from Tbl_Locations - using Lookup Wizard]
SessionID [Values from Tbl_Sessions - using Lookup Wizard]
Attended
1stEmail
2ndEmail
Remarks

Tbl_Categories
CatID [Primary Key]
Category

Tbl_Locations
LocationID
Location

Tbl_Sessions
SessionID [Primary Key]
SessionDates

----------------------
Question:
1. Any problem with the tables setup?
2. I am trying to link the tables in such a way that when I click on
- Tbl_Locations: I can see the different session dates that took place in each location
- Tbl_Sessions: List of new hires who attended the sessions
 
Back
Top