>Hi All,
>
>I've finally gotten around to retrofitting some older tables in my app with primary and foreign keys. Is there a method to "backfill" those tables with key values after they've been re-structured, avoiding the dreaded 'uniqueness of [key field] is violated' error? New installs aren't, of course, a problem. It's the existing installations that I'm referring to. My app uses VMP as a framework, and Stonefield DB toolkit.
If the question is "what value do I use for this one-time fill", the answer is simply recno(), or something based on it (I've seen recno()*5 at times... there are varying schools of thought out there).
The rest, as Tamar said.