Primary keys

[maulanday]

So I know what I did was a huge mistake. I made my primary key for my database as the project name, which often changes! So when I go to change the project name, then I lose the data from the other related tables. Is there way I can fix this?

Project_Management.pdf

[Breezer]

I would first create a new field in the PROJECTS table, say, call this field pk_project_ID (which will be an auto-enter serial ID). Show all records, then go to the first record field for pk_project_ID, input 1 then replace field contents (ctrl+=), then click replace with serial numbers. When done, go to field definitions and change the field properties to auto-enter serial, cant modify auto...

In your related tables, create the foreign key, say, fk_project_ID. In the field options for this foreign key, make it looked-up value, and specify using your current relationship. This will NOT be an auto-enter but should be of the same field type a the primary, ie, if primary is of type number, then this will also be number, etc...

In your related table, go to the field and perform a relookup. This will populate the field with the corresponding primary key.

When done, be sure to remove the option for lookup. Then from your table occurence graph, simply change the keys.

I hope I didn't miss anything crucial.