How create link to autonumber column?

[David]

I have 2 tables, Projects and Comments. Both tables have
autonumber keys. There can be any number of comment
records for a project and the link is made via the
autonumber key of the Projects table.

What do I choose for the 'Data Type' when designing the
comments table column to be linked to the autonumber key
in the Projects table?

Is there a standard method for handling tables linked like
this? The user will be able to choose a project and then
will be able to look at all previous comments, which need
to be listed in order of creation, (would I use the
autonumber key for this, or a separate timestamp field?)
The user will also be able to enter new comments.

 

[Gary Miller]

What do I choose for the 'Data Type' when designing the

comments table column to be linked to the autonumber key
in the Projects table?

This should be a LongInteger data type

Is there a standard method for handling tables linked like
this? The user will be able to choose a project and then
will be able to look at all previous comments, which need
to be listed in order of creation, (would I use the
autonumber key for this, or a separate timestamp field?)
The user will also be able to enter new comments.

You should probably use a Date/Time field for the time stamp
with the default value being Now() if you want the time as
well or Date() if you just want the date. You can now sort
by this. The easiest way to display these comments will be
the use of a subform.

Gary Miller
Sisters, OR