In all of our current databases, we use a (null allowed) ID field which auto-increments at every new row insert as well as a particular member ID (unique to every person and every row).
In essence, a person can be represented by ID=33 as well as MEMBERID=4839283789.
I have debated completely wiping the ID field and only using the MEMBERID as the primary key. Are there any advantages or disadvantages to either way?