>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.

OK I think I understand. Try this

#1 way
Select (the fields you want) from (the table you want) where (the condition you want) into cursor temp
Select temp
do your excel stuff to the ranges you want.

#2 Way
if you have an index created on the field
select mydbf
set order to myindex
if seek(mycondition)
do your excel thing.
endif


HTH
Jeff