I am editing something I wrote months ago. It does what I asked it to but apparently I asked it to do the wrong thing

If work_ordered = "delivery nc"


then
     {

           le14 = 0
     }

if work_ordered = "Tune & Check"

then

     {
     
                  le14 = @xuserselect("c:\sesame\data\prices.DB", "areas!Location:")

     }

It pulls up a list of the Locations just fine. What I wanted to do from here is to access the information for that location. Louisville tunings cost less than Bowling Green tunings (there is a whole list of services for each location) I'm sure I have seen something similar but all I can find now is pulling up comma seperated listings, alphabetized and everything. I MIGHT have 5 locations so I really don't need them alphabetized everytime. I am doing it this way so the person that sets the prices doesn't have to get into the programming to change them and they don't have to involve me everytime something goes up.

If I have overlooked something easy or obvious feel free to point me in the right direction

Thanx!

Hello,

maybe XUserSelectR is the function you are looking for.

Hello digimom,

le14 = @xuserselect("c:\sesame\data\prices.DB", "areas!Location:")
Price_Element = @XLookUp("c:\sesame\data\prices.DB", le14, "areas!Location:", "Price_Element_in_prices") 

You will need to replace Price_Element with the name of the element on the form that you want the price data to be filled into, and replace Price_Element_in_prices with the name of the element in the prices.DB file that has the data that you want returned for that location.

-Ray