> > If I have a table that has an integer field (ikey) and a character field (cname) and the integer field is the primary key. Is there a way in code to set the ikey field not to the primary key - append records - fill the ikey field with the appropriate key - set in code ikey back to the primary key? I know how to do everything but set the ikey field "not to a primary key field" and then "set it to a primary key field". TIA.
> >
> > Buffiie
>
> How do you deal with uniqueness violations. What I get from this Q is.
> I have a field that is a primary key.
> In code I want to change it to a non-primary (normal) key.
> After some hassling and fizzling I want to make it a primary key once more...
>
> but to answer your question, ALTER TABLE can do the trick.
>
> One more Q, what if that table is involved in a relation....
>
> Boudewijn Lutge®ink
> Boudewijn.Lutgerink@foxite.com
> Experience is the knowledge you get immediately AFTER you actually needed it...

See reply to Eric. If you have further comments please do so. TIA.
Buffiie