foreign key

  • Thread starter Thread starter Joanne
  • Start date Start date
J

Joanne

I have 2 tables, tblCourses and tblHoles

CourseID is primary key in tblCourses
HoleID is primary key in tblHoles

I need to put CourseID into tblHoles as a foreign key.

I know to use the relationships to relate Courseid from TblCourses to
CourseID as foreign key in tblHoles.

What I don't know is what data type does the foreign key need to be?

Thanks a bunch
Joanne
 
CourseID in TblCourses should be autonumber (which is Long Integer) and
CourseID in all related tables should be Long Integer.

You ought to be out playing a round of golf this morning instead of workng
on your database. That would be sure to improve your game!
 
Thanks fellas, and you're right Steve.
Playing is much more fun than this, but I must hang on until Monday.
Golf on
 
Back
Top