primary key: changing of ramifs

[stevepcne]

Hi,




Q. Can i change the primary key currently set to my products description to an auto number? I'm trying to make things right, also does the foreign key get an auto number? Thanks in advance...

[June7]

You can change but is a complex, tedious, and risky process if you already have data. The foreign key would be number datatype.

If you already have data, create the new fields, set properties. UPDATE the new foreign key field to the new Autonumber values. Change relationships. Will have to modify any established queries and form/report RecordSource statements. Delete old fields after sure edits went okay.

[stevepcne]

Thanks for the reply June7, You Rock!