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.