Forum Discussion
Join tables with two keys
Hi Guys, I hope you can help me with the problem I'm facing. I have two tables, let's say Contract and Revenue. Revenue | Customernr. | Subcategory | Subcategory (Groups) | Revenue in € | ...
I figured it out with the replies on this post.
I could not create a composite key in the query editor, because I have groups.
So I created a new column in both tables that uses the two columns and merges them as one. This is my key.
Now I could create a relationship between the two tables.
Anonymous Please create a column by merging Customernr and Subcategory (Groups) in Revenue table.
Similarly create one column by merging Customernr and category in contract table and create a relationship between two tables