General information
Category:
The Mere Mortals .NET Framework
Title:
Join or relate vfp tables prior to putting in dataset
HI,
Would someone please show me how to perform a vfp datatable query, via a business object function (C# please), that relates two tables prior to putting the result of the query in the dataset.
I have an appointments data table and a patients data table. The appointments table is small with PK = ID, FK=patientID. The patient data table is huge with PK=patientID.
Sure, I can bring over the 2 tables and then do the join in the dataset or set up a relation once in the dataset is filled with the 2 tables. But.... I would like to limit the size of the patient table query. This seems so simple in native VFP (set relation to or a select with join) but I am having trouble wrapping my mind around it in MM.NET.
Thanx,
Neil Gorin
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only