Try to set Listbox.ColumnCount=3
>
>Many thanks for your reply.
>
>I have modified the program per your reply, and I still cannot get it to work. Would it help if I sent you the database ?
>
>Basically, I have quite a few fields in my 'orhead' datbase, which is a purchase order header file. I have three initial fields named prefix,quote and code, and the idea is to be able to say pick a code, (customer code 6 letters) so I can see what is on order for any particular customer. I have typed in "orhead.prefix,quote,code" and in my choice box I only get a choice of prefix(characters 3), and no reference to the quote (Numeric 6) or code (Character 6). The prefix field is duplicated for every quote with the given prefix.
>
>Is there a required mod to any of the other lines in my program ?
>
>Sorry, I am a bit green with this version of Foxpro, having done all my previous programming in 2.6 DOS version.
>
>Help
>
>Would appreciate your input
>
>Thanks and best regards
>
>Michael Johnson