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