I have a table called Orders and the key is Order No + Delivery Number so a Computed Key is generated CONCATENATE([Order No],": ",[Delivery No]).
I have a table called Order Details which has a key called Request No.
An Order can have multiple Requests.
I am struggling with relating the 2 tables. I was able to do this when Order No was the key but now I have a multi column key and not sure what columns I need in Order Details to link the 2 tables.
User | Count |
---|---|
41 | |
30 | |
29 | |
16 | |
14 |