RE: Suggestions on querying parent/child records

2003-11-21 Thread Dan Greene
cs, or the many posts to this list...] > -Original Message- > From: Brent Baisley [mailto:[EMAIL PROTECTED] > Sent: Friday, November 21, 2003 3:06 PM > To: [EMAIL PROTECTED] > Subject: Suggestions on querying parent/child records > > > I'm trying to figu

Suggestions on querying parent/child records

2003-11-21 Thread Brent Baisley
I'm trying to figure out the best approach for doing this query. I have a list of action items, typically about 50, that I need to display. Each action item will have two related sets of child items (two different groups of people). So I need to query three main databases, a parent and two chil