Hello Marcus. Thanks for replying.

I have revoke insert/delete/update to the group by clearing the appropriate box.

But now all users in the group can edit the data in the tables, not...

Thank you all for your replies.

I will have no problem if i add a new identity column and make it a PK. and this is the quickest solution. 🙂

If...

I think it'll be clearer if I list my tables here.

MAIL:

[MAILNO] int, identity, primary key

[DATEJOIN] smalldatetime

[RETAILER] bit

[TITLE] varchar

[NAME_ML]...

My MAILNO is not a unique column, it is a FK to another table called 'MAIL'. Each MAILNO have 1/more interests and it is stored in this table. MAILNO is...