Linking multiple fields to one concatenated field.

[Former Member]

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"?

[Former Member]

Post Author: n8than1

CA Forum: Data Connectivity and SQL

Dave, Build the SQL Query in Query analyzer and using the "Add Command" to paste in the code. I've done some thing like this with the ARITEM, ARMAST, and SORELS tables to create an invoiced Sales report. So far ARTIEM is the hardest table i've worked with because of the way the data is in the fields for FSOKEY and FSHIPKEY , etc.....