Hi All.
I have an asset tracking database. Table 1 is used for tracking asset information and is often edited using a search form and submitting any changes. I want to create another table so I can keep a count of asset faults. As the Faults field in table 1 changes as and when a device is repaired, sent back out but then returns with a different fault, I have created a second table to save this info. When I make changes in the form, I want to update the Fault field in table 1 but also add an entry in table 2 allowing me to then query the total number of a particular fault at a later date.
What is the best way to copy the data from several fields to another table when editing table 1?
Hope this makes sense.
Thanks in advance
I have an asset tracking database. Table 1 is used for tracking asset information and is often edited using a search form and submitting any changes. I want to create another table so I can keep a count of asset faults. As the Faults field in table 1 changes as and when a device is repaired, sent back out but then returns with a different fault, I have created a second table to save this info. When I make changes in the form, I want to update the Fault field in table 1 but also add an entry in table 2 allowing me to then query the total number of a particular fault at a later date.
What is the best way to copy the data from several fields to another table when editing table 1?
Hope this makes sense.
Thanks in advance