Best Way to display details

[DEDMOD]

I'm relatively new at FoxPro and rather overwhelmed with all the possibilities when it comes to displaying data. I have a situation where I have one table with projects and another with details (hours worked) keyed to the project. What's the best way to display the details on the form with a given project?
I was thinking of using the click method of a "click here for details" label to pull up a form or user defined window to show the results of a SELECT - SQL search, but am not too sure if it's the best way, or exactly what code I need where.

 

[Walid]

Hi
In this kind of situations allways consider using the grid to display your child data. I assume that your form will consists of two frams, the 1st to choose the key information from the first table ProjectID or whatever, the 2nd will be the grid uppdated with the related information to the key. as usuall there are hundreds of ways to that that. you can create cursor and connect your grid to it then fill the cursor with the related information. if the key changes zap the cursor and fill it again. you also can set relation between the master and child files so your grid will automatically uppdated when the recored pointer changes in the master.

Run the solution application
*-- Change the path whatever you can see fit
SET DEFAULT TO "c:\program files\microsoft visual studio\msdn\2001jan\1033\samples\vfp98\solution"

DO solution.app
Choose Controls->Grid to run examples and to see code regarding this issue.
Good luck and willcome to VFP
Walid Magd
Engwam@Hotmail.com

 

[DEDMOD]

I suppose I can do it something like that, though I was thinking more just a pop-up and then double-click to close it. On the one hand, this is is a simple in-house project, so I don't need to be too fancy. OTOH, I'm also using it as a learning tool, so perhaps using a form set instead of multiple forms would be useful. Thanks for your input.
-- Dave