Using a grid for a search form

[D2C]

Hi there,

We are currently working on a form that should include a search option. I would like to call another form where the user can enter something to search for. If he/she clicks search, my grid should display the results.
After this he should be able to select an item in the grid and the selected item should go to my first form.

I am a newbie to vfp, using vfp 9. I already read about recordsources, but I don't find a good jumpstart to make this solution. Important to know, but I am not using sql but regular dbf tables!

Can somebody point me in the right direction? Or maybe a good tutorial for grids?

Tnx in advance,
greetz,

d2c

 

[crewchiefpro6]

Get the book 1001 Things about Foxpro, it has a whole chapter on this.

Basically if the end user highlights a row in the grid, the dbf will have that record selected, so all the first form has to do is call a thisform.refresh() to see the fields filled in. The more complicated part is designing the search criteria to load the grid.

You say you do not use sql, but you will to populate the records for your grids. Using SQL to filter records is the preferred method, it is fast and easy.

Make sure you follow the book exactly.

Don Higgins

 

[Mike Gagnon]

Take a look at faq184-1214

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[D2C]

thank you both on this advice!
greetz
d2c