Field Dependancies

[red7]

I have two tables:

tblMembers:
MemberID (Primary Key)
Title
Forename
Surname
etc...

tblGymAttendance:
Attendance ID (Primary Key)
Member ID (Linked to MemberID in tblMembers)
Forename
Surname
etc...

How do I get the Forename and Surname fields in 'tblGymAttendance,' to be dependant on the MemberID field in the same table?

eg. when I input a new MemberID in tblGymAttendance, the relevant details can be filled in into forename, surname etc, which are taken from 'tblMembers'

Apologies if solution is very simple but I'm a newbie and this problem is preventing me from moving on to do other things within my database! Help greatly appreciated!

 

[KenHigg]

You don't store them in two places. That's the essence of relational databases...

Start by reading this: Link


Ken

 

[jhustblue]

Exactly!

Thats eactly the basis for relational databases. You are only supposed to store information pertaining to one person/customer on one spot.