foreign key

[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

 

[Dan Artuso]

Hi,
It must be the same data type as CourseId in tblCourses, whatever that is.

 

[Steve]

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!

 

[Joanne]

Thanks fellas, and you're right Steve.
Playing is much more fun than this, but I must hang on until Monday.
Golf on

 

[Larry Daugherty]

Long Integer