>WOW
>I was looking for guidance on which way to go.
>And you provide me with better code than I have written so far and a solution.

I am glad to be of help.

>You are a mensch,
>Carol Dewar

That I am a "person"? I mean, what else did you expect? Ha, ha!

I didn't previously know this term in English (http://www.britannica.com/dictionary?book=Dictionary&va=mensch lists it as "A person of integrity and honor") - only the German word, which means "person". The link above also indicates this in the ethymology.

Back to the database update: the framework I use, Visual Extend, excels in many areas, but there are a few areas where improvement is needed. The "client-site update" is one of them. If both the parent and the child table are modified, there is no guarantee that the parent is copied first - and it is here that the c.s.update fails miserably (trigger failed).

I ended up creating my own c.s.update (the "clients" are the users at the company I work with), and only used the function vfx_needupdate(), since I didn't want to rewrite that one. That is the function I can't post here, of course. VFX is the letters used by most Visual Extend programs, libraries, etc.

I also did some fruitless efforts to convince them to do the same - they claim it would still fail under certain circumstances. (In their defence, not all ideas submitted are rejected. Some of my own contributions eventually made it to the framework.)

Hilmar.