Hi,

1. How can I execute a Trigger on an Access table on an UPDATE (on a specified field), using VBA/SQL?

2. I then need to produce/export a XML document from the table (or tables using a one-to-many relationship), how do I do this?
Note: This has to be performed on the UPDATE.

EXAMPLE:

[u]Table_A</u>
Field1 = Order Number
Field2 = Status field (when Updated to ‘C’)

[u]Table_B</u>
Field1 = Order Number
Field2 = Line Number

Thanks in advance,


Neal

A Northern Soul

__________________
Neal

A Northern Soul

Access (Jet) tables don't support Triggers.

Bob