Table Look Up

[bob.bud]

Help,



I have a simple table Tbl_class_status which tracks location and status (open or closed), this table has the following fields:
ID - default Access ID
date
location
status

I have an attendance table that has several fields to help me track who attended; however, I need help with pulling the location from the class_status table. I am assuming I can use the date field as my relationship. This is probably short sighted on my part given the likelihood of duplicate dates, please help. Here are some of the fields for my attendance table
ID - default access ID
fname
lname
studID
dept
there are a few other fields but they just capture other data regarding the indivual enrollment.

Thanks

[June7]

Linking on date bad idea. You don't even show date field in attendance table. You need data structure like:

Tbl_class_status

Tbl_Students

Tbl_StudentAttendance
ClassStatusID (foreign key)
StudentID (foreign key)

[bob.bud]

Thanks June7.

I am sure I did not do exactly what you were thinking; however, I did get it to work.

Happy New Year