> I have written this Rodeo software and every rodeo has a New set of Cowboys that I get from the Professional Rodeo Cowboys Assoc. in a download. So what I really doing is recreating my data for every rodeo and I use the contestant number as a primary key that relates to tables of events they are in like Bare Back and Bull Riding. So I import the data but since I get to assign the contestant number I just want to import the data without a number to begin with and then assign it. Since I have the contestant number as a primary key I just need to turn if off - assign it and turn it back on. Boudewijn indicated that I could use Alter Table and I tried it and it worked. I am not sure that is the best way but I am thinking about putting in a cursor assigning and then putting in the table. I also recreate all of the child tables at the same time but since it is always New Data it really does not make any difference..... Thanks for your time. If you have any thoughts on Alter Table I would like to hear them.....
> Buffiie

ALTER TABLE requires exclusive access to the tables. Not really an option if your app is used in a multi-user environment.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts