Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Relationships between tables?
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access training - Relationships between tables?
Resolved · Low Priority · Version Standard
Reply Mon 9 Jul 2007, 16:01Delegate Gemma said...
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
For upcoming training course dates see: Pricing & availability
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
|