Although it is not the most elegant solution, it will work for this application. 1. First I run a query to get the engagement masters 2. Then I loop over the engagement records to display them 3. As each engagement record is displayed, I run a second query that uses the field containing the list of consultant IDs with an IN clause 4. I then loop over the records returned by this query to display the consultant names If I had thousands of engagement records, this would not be the best solution but for now, this works. ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
