Your Input and link record to the date it is entered
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.
--
Build a little, test a little.
"Teddy" wrote:
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?
|