>>>I want to change the value of a field in a particular record in one DBC based on the result or event in another DBC.
>>
>>I would probably use an UPDATE TRIGGER that is a function call to a SP in the DBC. In that procedure, I would then update the other table in the other DBC. Keep in mind the UPDATE TRIGGER fires if any field is updated in the record, so I would do some checking with the GetFldState function[row or table buffering required].
>
>In my experience, if buffering is used, the trigger doesn't fire with every field change, but only when you do TableUpdate() (or when you have record-buffering, and leave the record).
>
>The rule that the trigger fires for every field updated does apply when no buffering is used.
>
>Hilmar.
Yes I know. I would only want this kind of updating upon record validation and not filed validation which is why I suggested an Update trigger instead of a field validation rule. Also, IMHO, no one should be working with the tables directly. They should be using views or cursors.
Mark McCasland
Midlothian, TX USA