Will Mem_Membership_ID have a different value for each record?

Assuming that it is the case, will the values for it ever be edited, or are they just added and then left?

Assuming they are not edited, it would be a very good choice for a primary key.


If either of those assumptions are not correct, creating another field for it might be a good idea.