Contact Management Database Template

[kailuo]

Dear All,

I download Contact Management Database template from Microsoft website and found it very useful. But I have a problem to change primary key from contact ID to first name. (the reason being is that I don't want to duplicate on my customer information)

Each time when I do, following will pop up "This table is primary table in one or more relationships.", I then tried to delete relatioons table and failed.

Can anybody help? Thanks in advance for your help.

Regards,

kailuo

[FishVal]

You may just create unique index on [first name] field (though I suppose you would like to create a multifield index on first and last name fields) to ensure the field to have unique values.

Regards,
Fish.

[NeoPa]

As Fish says, it's better to add an index on the first Name field rather than trying to fiddle with the PK. PKs should only be changed with a good understanding of the overall effect.
However, it's very rarely a good idea to make a First Name field a unique index as generally, they just aren't.