Is it bad practice to create relationships between tables where the PK is an identity AKA auto incremented?
The reason why I ask is, while identity keys won't repeat, they are set based on the order that someone enters data, so the first entry is 1, second is 2 etc...
If the data is exported, or somehow backed up and needs to be restored, is there a chance that those numbers could change?
For some reason I seem to remember someone saying back in my VBA MS Access days that PK shouldn't be auto increment. I can't remember why though?