Forum Discussion
Working with shared postcodes (different business in the same building)
Hi I'm working with a set of data from a National body that shows every public medical practice in the country. I have a set of customer data with the practices which are already a customer....
Hi James
A key does what is says in on the tin.
If the key fits 5 door locks then you ned to try use soome of the other properties to try decide which is which.
If you cant and wnat to over come the duplicate key error, then that is easy !
Just add an index column to your query (1,2,3,4,5,6, etc) then add this as decimal to your key
eg key 77.3, 77.4, 77.5.
So you joint key (77) and unqiue keys (77.3, 77.4 and 77.5).
Hope that make sense.
Please click the thumbs up and accept as solution 😁