Neil,
1. Create a view to select the data that you want to display. Make sure the view is updateable! (SendUpdates, KeyFields, Updateable fields all checked)
2. Drag and drop the view on the form.
VFP will create a grid for you and set Rowsource & what not.
3. Now drag & drop a combobox on the appropriate column. Make sure the column has the focus when you do this, otherwise it'll just land somwhere on the form.
4. Set the columns currentcontrol to the combo's name
5. Set the columns Sparse property to false
There is of course, as always, a bit more to it, because you should really do all this with a subclassed grid & combo.
Speaking from experience, the combo may give you some grief as well, but these are the basic steps.
HTH
>I have just created a grid on a form. I am having a nightmare with it mainly because I haven't worked with them that much.
>
>The grid has 2 columns:
>TextField = Percent
>ComboField = Type
>
>1, I want to have the Type field to display a list of values from a table (standard.types)
>
>Note: When editing the grid then properties I cannot see the rowsource and type property
>
>2, I want the grid to display those record from cmscomp where cmscomp.artikey=article.artikey
>
>Note: Dont know how to do this.
>
>3, I then need to be able to add a record in the grid which updates the table.
>
>The problem I have is that I cannot add records in the grid even though the properties have been set to allow editing and it is enableb.
>
>Any help would be grealt appreciated
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)