>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.


Most people might suggest that you create a VIEW of the two tables and use that as your grid source... If not, you can always have SET RELATION in the form when the tables are open, and just make the controlsource of the specific columns to the proper alias.field of their respective tables.