Once you have the record pointer at the correct record, you access the field data this way: TABLENAME.FIELDNAME

So if the table is called Customer and the data you want is in the LastName field, you would use Customer.LastName or, if you prefer, Customer->LastName.

Joe

>Geting the data over to excel is no problem (once I switched from DDE() to VBA. DDE was giving me a nice BSOD :)
>
>Since none of the customer information isn't displayed on the form (except for a customerID which is in the labratory test table) I cant just grab those items that I want to send over..
>
>Every example of SELECT I have seen dumps the results to a browse window, or a report. I want to SELECT a specifit record (using a unique customerID) and use the data in tha records fields programaticly. (To send to excel (which I can do))
>
>Strangly enough the book I have seems to assume no knowlage of database design or construction, but lots of foxpro-syntax abilities. I guess since I know something about databases (at leas enough to get me into troble), and enought about programing (though not so much VBA) what I realy should have gotton was a VFP-cookbook.