I would like to have a dict item that returns only the first value of a mv list. Right now I have an edit table that lists

1. ax bx cx

2. ay by cy

3. az bz cz

4. ca

5. cb

The extra c values could be from row 1 or 2 or 3. If my dict item

could return only the first value of the mv list in column 3 using

the key in col1 then rows 4 and 5 would not be applicable.

Suggestions?

B.,

What about something like:

MyVal=XLATE( "TableName", "KeyVal", "ColumnName", "X" )

Does this not do what you want?

msorrel@greyhound.com

No that wont do it either.

You get a list (because column3 is an associated value) of

1. ax bx cx

2. ay by

3. az bz

I just ended up writing code.

open "F1" to F1.file then

   open "F2" to F2.file then

        scodes=@RECORD

        array="

        tots=count(scodes,@VM) + (scodes  "")

        for x=1 to tots

            ID1=scodes

            read item1 from F1.file,ID1 then

                 ID2=item1

                 read item2 from F2.file,ID2 then

                      array=item2:", ":item2

                 end

            end

        next x

   end

end

@ANS=array

Thanks

View this thread on the forum...