Restoring Data To Tables With Auto Numbers

[cdacey]

I have created a application with a "customer" type table that has an account # field that is auto-number field type. This is the field I used to link to all other tables. I am concerned that I may not be able to restore data to a new customer table when I upgrade the application due to the problems with auto-number fileds. Any thoughts on how to handle this ??
Thanks Chris

 

[Rich]

What do you mean by Upgrade the application?

 

[cdacey]

Upgrade

Rich,
My thought is that once I package & deploy the application, I will probably add new functionality to it over time and then repackage a new application (with no data). I woul dthen need to import the table data that a user has been building on the old application. With Many of the tables, I have tied everything together and built relationships by that "acc #" field, and I am unsure how I would be able to restore the old table data to the new application, and keep the same account #'s, especially when the auto-generate? And if the system assigns new account #'s, how will that effect the related table data ?
Chris

 

[cdacey]

Thanks !

Pat,
Thanks, That was very helpful.
Chris D