Shape Command using concatenated keys

[gadgetguy1111]

Hello,

I'm trying to write a shape statement to relate one table to another. the problem is the fields relating these two tables together is concatenated. so a command like

shape {sql statement1} as Header
append ({sql statement2} as Details
relate Header.field1 to Details.field1) as Details


will not work.

any ideas how i can include a
relate Header.field2 to Details.field2
to the above command?

thanks.

--
Boon Kee