Adding fields from DOLINE in SOP backorder Report

richardd

I have a requirement to add the doline.reqdat field to the SOP backorder Report. I know the syntax for the seek command to pull the field from another table but Pegasus are not opening the table I need when running the report. Does anybody know how I can open a table from with-in the report?

alan-bourke

In general sqopen() can be used. For example:

iif(sqopen("S", "operatable"), iif(seek(yourvalue, "operatable", "indextagtouse"),operatable.returnfield,""),"")