C
ccutayar
Guest
I have two tables that contain the same fields except for an additional primary key field within the second table. Table 1 is my main table and Table 2 is to be a history table for each record contained within Table 1.
If I change any data within a record in Table 1, I want it to show up within Table 2. So if in a day I make 4 changes to record 1, then I should view 4 changes for that day and for that record in Table 2.
I am working with Forms and Subforms to achieve this, but I cannot get them working. I have gone so far as to see the history of a record in Table 1, but any changes I make, just get updated, Table 2 does not create a new record showing the changes.
I have also tried append and update query, but no luck.
I really hope you can help me.
Many Thanks
Cathy
If I change any data within a record in Table 1, I want it to show up within Table 2. So if in a day I make 4 changes to record 1, then I should view 4 changes for that day and for that record in Table 2.
I am working with Forms and Subforms to achieve this, but I cannot get them working. I have gone so far as to see the history of a record in Table 1, but any changes I make, just get updated, Table 2 does not create a new record showing the changes.
I have also tried append and update query, but no luck.
I really hope you can help me.
Many Thanks
Cathy
