G
Guest
I have a database that collects survey-like information about states.
Currently, I have it designed to collect all the question responses in one
table. The problem is that the responses will be periodically updated and I
need to be able to keep a record of all responses, not just the current ones.
So, I currently designed the table to have State Name and Modification Date
both as primary keys. So, there can be mulitple entries for a single state,
as long as there are different modification dates.
It seems like a better way to do this would be to have a master table with
only the most current responses (most recent Modification Date), and a
history table to store all the previous responses (older Modification Dates).
But I'm having problems figuring out how to set up these two tables. How do I
allow only the new record with the current Modification Date to be entered
into the master table, and move the older records to the history table
(deleting them from the master table at the same time)? I don't do VB
programming, so I'm trying to do this all with Forms, Macros, Controls, etc.
I hope this makes sense. Any help would be greatly appreciated. Thank you!
Wendy
Currently, I have it designed to collect all the question responses in one
table. The problem is that the responses will be periodically updated and I
need to be able to keep a record of all responses, not just the current ones.
So, I currently designed the table to have State Name and Modification Date
both as primary keys. So, there can be mulitple entries for a single state,
as long as there are different modification dates.
It seems like a better way to do this would be to have a master table with
only the most current responses (most recent Modification Date), and a
history table to store all the previous responses (older Modification Dates).
But I'm having problems figuring out how to set up these two tables. How do I
allow only the new record with the current Modification Date to be entered
into the master table, and move the older records to the history table
(deleting them from the master table at the same time)? I don't do VB
programming, so I'm trying to do this all with Forms, Macros, Controls, etc.
I hope this makes sense. Any help would be greatly appreciated. Thank you!
Wendy