Hi Mike,
once you've ordered the book you can download the e-book so you don't need to wait on the physical book to arrive.
Also, you could check out Marcia's papers on combos at tightlinecomputers.com
(I think this is the one I'm thinking of, but you need to be a FoxPro Advisor subscriber to read it:
http://msvfp.advisorguide.com/Articles.nsf/aid/AKINM03)
I would guess the codemine app is VFP8 or 7, you can locate the runtime files for those versions on line.
>Thanks Carole! I just ordered that book, as well as "Build Your Own Framework with VFP". I am still debating whether to invest in a 3rd party framework like VFE. I did use their FPD & FPW tools. I just went to Codemine's site and d'loaded their sample appl, but it won't fire up under VFP 9 (can't find VFP library).
>
>
>>There is a section of chapter 6 in the book: "1001 Things You Always Wanted to Know About Visual FoxPro" Hentzenwerke Publishing that answers the question:
"How do I add a combo box to my grid?"
>>
>>If you don't have this book, go right now to the Hentzenwerke website and order it. It is definitely going to save you time ... and time is money.
>>
>>>>New to VFP, I've now got about 30 hours into trying to make a grid work with a combo box. Here is a simplified outline of what I am trying to do. Greatly appreciate any suggestions!
>>>>
>>>>I have an invoice detail table(I) and a products table(P). I defined my grid's RecordSourceType=Alias, RecordSource=I etc. I want my grid as follows:
>>>>
>>>>Part# Description Qty Price
>>>>------ ------------- --- -----
>>>>
>>>>Part# - combo box: 0-Dropdown, RowSource=P.PartNo,PartDesc, ControlSource=I.PartNo
>>>> dropdown list will display "Part# | Description"
>>>>
>>>>Description - text box - ControlSource=P.PartDesc (read-only, not saved in I)
>>>>
>>>>Qty - text box: ControlSource = I.Quantity
>>>>
>>>>Price - text box: ControlSource=I.Price
>>>>
>>>>
>>>>My problem is that a grid configured this way behaves quite odd: when the combo's list (Part#) drops down, it clears the instant I press any key. I think VFP is seeking in the Products table, trying to update the Description column? But shouldn't the combo remain dropped down until user selects something, hits ESC etc ? If I change Description column's ControlSource to (none) and its text box's Value property to "Test Description", the Description column will display "Test Description", but ONLY when that column has the focus (blank otherwise). So I guess my question is how do I display a calculated value for a column - regardless of whether column has focus ? Again, setting Description column's ControlSource=P.PartDesc causes all kinds of screwy behavior with the Part # combo box.
>>>>
>>>>I have a hunch I could avoid all these problems if I used an array RowSource for the combo. But I really want to learn from this "episode". I hate giving up :)
>>>>
>>>>Many thanks!
>>>
>>>>
>>>>PS. How do you change UT forum messages to use fixed fonts, so columns line up?
>>>
>>>I guess the fact that MS does not include any samples that demonstrate combo boxes in grids is indicative of the difficulty of this task? I would have thought this was a relatively straightforward task, but maybe not :(
