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.
You are a mensch,
Carol Dewar
>>Have you automated this? done this remotely? Any "Lights out" problems? considerations?
>
>I will include my program; one thing I can't include, because it belongs to the framework I use.
>
>You will therefore need to provide the Table_Needs_Update() function. For a quick start, let it provide "new table" for new tables, and "there are changes" for all others. You can add commands to check for changes (and return "no changes" as appropriate) later.
>
>The basis for the following program is: create a list of tables, create a list of relations, loop through all tables and update them, postponing tables that are on the "child" side of a parent-child relation for the next iteration of the loop.
>
>HTH, Hilmar.
Carol Dewar
Magram Computer Services LLC