Hi Everyone,
This might be a very easy question for you guys.
I am using Codebase 6.0 and Visual C++
I have two tables
Table 1: //has information about activities
ActivityID Auto Inc Numeric
Date Date/Time
ClassID Numeric
.....
Table 2: //has more details about items inside the activity
ActivityID Numeric //from Table1
Someother data
I want to get all the records in table 2 based on this query on table1 (
"Date >= StartDate .AND. Date <= EndDate .AND. ClassID = Class"
How do I setup the relation****p to do this?
I suppose I can do a query on table 1 to get all the activities that match
the query string above, and as I get each activityID, I can do another
query
on table 2 to get that information. I would rather do it in one shot but
don't know how to set it up.
A code snippet that shows how to setup the Relate4set and Relate4 would be
greatly appreciated
Thanks
AliR
