I can get this to work (getting a list of product status for the selection)
WHERE IM_STATUS EQ &STATUS.(OR(FIND IM_STATUS IN IM_INVENTORY)).Select a Status.;

instead of that...can i get the list to pull from a small flat file instead of the table? i set up a small flat file and created the mas (ran a test report to make sure it worked) but it won't populate the list. or is there a way to have a set list to select from instead of having a find?

thanks

This message has been edited. Last edited by: Kerry,

You can, as long as the flat file is FILEDEFed in the profile.

i included

SET PCOMMA=ON
APP FI STATUS DISK BASEAPP/status.txt
-RUN
SET ALL=ON

but will check out the FILEDEF

APP FI is the same as FILEDEF.

FILEDEF has OS pathing, where APP FI uses appdirectories.

I assume you also have a MASTER file for the flat file ?

yes, i have a master file. i can run a separate report from it..but when i try to use it to populate the list, the list is empty. i'll try again today.

thanks

an update....i haven't had a chance to finish this..so consider this closed and will open a new discussion soon if needed

thanks for your help.