Forum Discussion
Connect two tables
RicardoSousa198 Well, the best practice is to use a unique key between the tables but it sounds like you don't have that. I don't know your data, but sometimes its possible to create a unique key column by appending columns together. Like Key Column = [Column1] & "|" & [Column2].
But, I don't think that's going to help in your case. You need better data is what it sounds like.
RicardoSousa198 The image shown indicates that the tables are linked successfully. Or was this a mock-up of what you want?
Hello Greg_Deckler
thank you very much for your answer
The image is my connection. The connection works.
As I have the connection made using the client's name, which is not the most correct, because there may be people with the same name, I would like to know if there is any way to make another connection.
What are the best practices in this case?RicardoSousa198 Well, the best practice is to use a unique key between the tables but it sounds like you don't have that. I don't know your data, but sometimes its possible to create a unique key column by appending columns together. Like Key Column = [Column1] & "|" & [Column2].
But, I don't think that's going to help in your case. You need better data is what it sounds like.
