Gemma has attended:
Access Introduction course
Access Intermediate course
Relationships between tables?
If I want to link two tables do they need to have a unique key that they share or would a matching address field i.e. postcode be enough?
I have a database that my company uses. It records the contact details of our customers. We also purchase a list of UK Businesses. I would like to add information from that list to our database. However due to us using a different type of recording ID's to the purchased list, the only thing they may share is address details such as postcode.
Can the postcode be the relationship?
Thanks
RE: Relationships between tables?
Hi Gemma
Thank you for your question.
I would say that you couldn't use the postcode as the primary key as there is a small chance that you could have more than one business that has the same postcode. The primary key definitely has to be unique for each business.
Amanda