>Although I have a background in procedural xBASE programming, I am still trying to get over the learning curve in VFP.
>
>I am trying to build an application wherein I am working with two tables. One is VAC.DBF and the other is PRLINK.DBF.
>
>PRLINK.DBF is a master employee file; thus, it has all the main employee information that I need to display, such as Fname & Lname.
>
>Whereas VAC.DBF is a vacation records file and is related to PRLINK.DBF via Employee Nmbr. VAC basically just consists of dates and descriptions of hours earned and hours taken for vacation.
>
>I have created a form with some combo boxes on it so that the user can select by employee nmbr or by employee name to see the vacation records for that employee. I know that I can programmatically create a BROWSE which will display the fields that I need to display from both VAC.DBF & PRLINK.DBF. But, I am trying hard to make the switch to the OOP paradigm, and it seems that a grid is more robust than a browse. However, in using the Grid Builder, it tells me, "Select a database or free table, and then select fields from ONE table.
>
>Obviously, I need to display fields from BOTH tables.
>
>Help would be very much appreciated.
>
>Thanks.

There are many ways to bring up data from different tables in grid:
1. Common way- create a view/cursor.
2. Shaky way- set up temp rlationships and set Column.Controlsource to different fields from related tables.
3. Specific way- use customized Column.Controlsource to SEEK() values from lookup tables.