Forum Discussion

pji's avatar
pji
Advocate I
8 years ago

Create relationships using 2 columns as primary key

Please allow us to create relationship between two tables using a combination of 2 columns instead of single column, if none of the single columns have unique values. Sometimes it is not possible to ...
Need Help
Tips and Tricks
jthomson's avatar
jthomson
Solution Sage
8 years ago

You could create a column concatenating the two you want to use as a workaround?

pji's avatar
pji
Advocate I
8 years ago

That won't help in my case, since I am making a generic template and the base table would be deleted and readded every time. I would like to minimise the effort as much as possible.