I have a table called Households which has an autonumber field called lngHouseholdID. Normally I would set this as the key field. However, I need to make sure that as records are being entered the combination of the strHouseholdAddress field and strHouseholdZip fields are never duplicated. I have done this by setting these two fields together as the key field. Is this the best way to do what I want to do? Just need some validation that I'm on the right track.
Thanks