Hi,

I am working on a solution to pull data out of our IMAGE database into FM v5.5. Pulling the data out of IMAGE isn't a problem, but I am not sure how to make the query I want dynamic. Here is a cut down version of the query:

SELECT WOSHT.SHTWO, WOSHT.SHTPN, IM.DESC, WOSHT.SHTQTY, IM.SCODE

FROM MANDB.IM IM, MANDB.WOSHT WOSHT

WHERE WOSHT.SHTPN = IM.ITNO AND ((WOSHT.SHTWO='123456'))

Instead of hardcoding '123456' I would like to use a global FM field.

In summary, I want to query an IMAGE database from FM using a FM field as the variable.

Is this possible?

I had this problem a while ago. What was suggested to me was to put the SQL code into a calculated field. That way you can have your SQL code in one field accessing variable data from another field.

Cheers.