If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Your Input and link record to the date it is entered
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
Your Input and link record to the date it is entered
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. "KARL DEWEY" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|