Relating records with a multi column key

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.

0 4 1,484
4 REPLIES 4
Top Labels in this Space