Find based on range between two fields?

[chrismarriott]

How would I preform a find based on a user selcing a price (from a popup list) for a low end and a price (from a popup list) for a high end - having the find come up with the range between.

I can do it manually if I enter it all into one field and use the range modifier.

There is only one field - price per item I want to find.

Thanks for any help,

Chris

[LiveOak]

gStartPrice (global, number)

gEndPrice (global, number)

Enter Find Mode()

Set Field (Price, gStartPrice & "..." & gEndPrice)

Perform Find()

-bd