Table linking problem 1

[ajdesigns]

Hi
I am running cr 8.5 with sage line 500 / MS 2000 server backend.
I need to write a report containing 2 tables. The problem is table 1 "stock" has fields warehouse, product, qty, price, etc. and table 2 Stock dets has fields Warehouse/product, commodity code, country etc. Table 1 has individual fields for warehouse and product whereas in table 2 these fields are combined into warehouse/product.
How then can I join these tables eg product(table1) to warehouse/product(table2) thus enableing me to get the commodity code for a product in table 1.
Thanks in advance for any help.

 

[lbass]

Gary,

In 8.0 there is no currency symbol for the order amount field (it is of number datatype). If I try your formula (it would at least pick up the second character in the field), it still does not work (with an ODBC connection). I'm not sure why this would work for you and not for me...

-LB