>The SELECT command I am still "playing with" CURSOR also for that matter!
>
>I tried what you said and I am still back to Alias "as an example" ("Blueberry" or
>"Redwood " are 2 of the Nurseries more popular sellers) either Alias is not found
>
>If you have any more ideas I am appreciative.
>
>Thanks,
>
>Fred W.
At the time you issue "REPORT FORM ....." has the data all been gathered into one cursor or do you have one main cursor with one (or more) related cursors?
In either case, could you post some dummy date. Use the < PRE > and < /PRE > tags (without spaces) to format the data in a monspace font. For example
Main Data Table
Strain Type Color ItemNo Quality
Blueberry bush blue 1 High
Blueberry bush blue 2 High
Blueberry bush blue 3 High
Blueberry bush blue 4 Low
Apple tree red 1 Medium
Apple tree red 2 Medium
Apple tree red 3 Medium
Rose flower pink 1 High
Rose flower pink 2 High
Rose flower pink 3 Superior
Rose flower pink 4 High
Rose flower pink 5 Superior
.
.
.etc
This way, you might get more exact help, rather than psuedo code you need to interpret.