Re: Efficient Code

You can use different screens, one depending on the previous, to go deeper and
deeper into the selection criteria.  This is also depending on how nice you can
associate the fields between them.

For example:

Page 1: Enter the required fields.  (Maybe all logicals have these fields in
common)
Page 2: Fields that are related between them, ie. general information as:
product type, class, unit of measure, etc.
Page 3: Additional optional fields in Etc.

You can use any of the existing logical files to do the type of search you are
looking for, as far as you can, one per page.  Then data selected will be
subject to be analyzed by the next selection criteria on the next page.

We have similar logistics in several of our applications and also MAPICS does
the same in other modules, for example.

Just an idea...

Peter Vidal
Pall Aeropower Corp.
SR Programmer Analyst
WWW.Pall.com
"My religion consists of a humble admiration of the illimitable superior
spirit who reveals himself in the slight details we are able to perceive
with our frail and feeble mind."
Albert Einstein