>>Something like Scatter Name? Mmmm... nope, there's no insert from name. A simple scatter ... memo should do, since the structures are identical.
>
>Something like "SCATTER MEMVAR MEMO" and "INSERT INTO ..... FROM MEMVAR", but I haven't had time to check it out yet. Memos have a reputation for corrupting very easily, and I've stayed away from them until this transgression... I should repent , :), and replace the memo field with a linked rtf file, like I always do.
That will work in your case, even if the structures aren't completely identical - you can have more or less fields, memos converted to strings and vice versa, numeric values of different length etc.
Come to think of it, most of our code is in memos - just look at the structure of .pjx, .vcx, .scx, .mnx and .frx files, and it's so in the last four versions. Haven't seen memo corrupted in quite a while. Maybe the last time was at home, in FPD2.6 after a power out.