Question How to create Relationship with duplicate records ?

[hullstorage]

Hi all,

Please see attached picture where I am stuck at?

I have a table that holds UK Postcodes and a customer table that holds customers.

I am trying to create a relationship between the 2 so when I enter a postcode in the customer table this is then related to the postcode table.

the main problem I have is that there is a lot of duplicate postcodes in postcode table so the primary key is simply a number as you will see in the picture.

Any help please?

Thanks

 

[Rabbie]

The picture you want us to look at is not showing for me. It would be helpful if you could post the picture

 

[hullstorage]

ooops, forget to add it!

here it is, thanks

simon