Your Input and link record to the date it is entered

[Teddy]

I have 6 activities; I want to keep a record of the Quality, Duration,
Consistency of each using a database and I am looking for input and help
planning this out.

The way I am looking at it is that each activity should have a separate
table. Therefore I should have six tables?

tblActivity1
tblActivity2
tblActivity3
tblActivity4
tblActivity5
tblActivity6

Each table will have 4 fields?

Today’s date
Quality
Duration
Consistency

I want to link each record to the date that I entered the record.

My two questions to you are, would you advise a different design for this
database than what I am currently suggesting? Do you know how to design the
table so that each record I enter is linked to the exact date that I entered
the record?

 

[KARL DEWEY]

One table (maybe two, see below).
tblActivity --
ActivityID - Autonumber - primary key field
ActivityType -
ActionDate - DateTime datatype - default =Date() or =Now() if you want
time also.
Quality -
Duration -
Consistency -

The default automatimatically enters current date/datetime when record is
created but can be edited.

If you create a table containing a list of activities you could select the
ActivityType so that there are not typos. A list or combo box can have a
built-in list or use a table.

 

[Teddy]

Thank you Karl, that is some great advice. I followed it to the "T". I
still have one more question if its not too much to ask. I am not having any
success getting the combo box to display the different activity types using
the combo box wizard. Do you have any recommendations.