Linking multiple fields to one concatenated field.

Post Author: DaveChel

CA Forum: Data Connectivity and SQL

I'm dealing with two tables that aren't directly related in my database. My Sales Order Release table and my Shipping Items table. There is a foreign key in the Shipping Items Table for the Sales Order Release. However that key is: sorels.fsonosorels.finumbersorels.frelease So, it's a concantenated field. How do I link this key called FSOKEY in my Shipping Items table to those fields in my Sales Order Release table(sorels)? Is this a situation where I'd have to build the SQL Query myself and put it in as an "Add Command"?