newbie sorry

[adamsmith_hrs]

Hello

sorry if this question is answered somewhere else i did check through the forum a bit first

anyway to the question

is there a way in access 2003 so when i change a value in one table it creates a new record in another table

example

i have a table called tickets and one called fixes, when i change a value in a record in the tickets table i want a new record in the fixes table to be created for me

any help would be great

ADAM

 

[ghudson]

Tables do not have events so would not be able to do as you have asked. It would have to be done within a form. But then again, why?

I also trust that you are not allowing the users to access and edit a table directly.

Also, your question sounds like your data is not normalized.

 

[RV]

You'd have to use forms plus a bit of VBA.

RV

 

[wkalo]

Hi

I Agree With Above Posts......

Attach Sample Database And I Will What I Can Do That Is If You Haven't Solved Your Problem .......

 

[RuralGuy]

It is the same concept as an Audit Log. That should give you a good starting spot. You could also do some searching on Audit trail or Audit Log for additional examples. I believe there is a good one in the code base of this forum.

 

[ghudson]

Here is a popular thread with a great Audit Trail sample.