I have a question pertaining to multiple selection query that is part of the RecordSource of my ADODC. I would like to select information to appear in a flex grid based on two criteria (LEGACY_FIELD and LEGACY_FILE) and for now I can select on only one criteria (LEGACY_FIELD). Here's the actual query:
SHAPE {select LEGACY_SYSTEM,LEGACY_FILE,LEGACY_FIELD,TYPE,LENGTH,CONVERT_FLAG,PRECISION,FIELD_DESCRIPTION,TARGET_SYSTEM,TARGET_FILE,TARGET_FIELD,TRANSFORMATION_RULE,CONVERSION_DEFAULT_VALUE,VALIDATION,COMMENTS,UPDATED_BY,DATE_UPDATED from KMD_LEGACY_MAPPING Order by LEGACY_FILE} AS ParentCMD APPEND ({select TARGET_SYSTEM, LEGACY_SYSTEM, ISSUE_NUMBER,LEGACY_FILE,LEGACY_FIELD,ISSUE_CATEGORY,STATUS,UPDATED_BY,OWNER,ASSIGNED_TO,RESOLUTION,DATE_UPDATED,DATE_ENTERED,RELATED_TO_GLOBAL_ISSUE,ISSUE_DESCRIPTION,ISSUE_COMMENTS,RESOLUTION_DATE,DETAIL_MASTER_UPDATED,ESTIMATED_COMPLETION_DATE from KMD_ISSUES_LOG Order by TARGET_SYSTEM } AS ChildCMD RELATE LEGACY_FIELD TO LEGACY_FIELD) AS ChildCMD

This relationship appears towards the end of the statement "AS ChildCMD RELATE LEGACY_FIELD TO LEGACY_FIELD) AS ChildCMD" I tried using "LEGACY_FIELD TO LEGACY_FIELD AND LEGACY_FILE TO LEGACY_FILE" and "LEGACY_FIELD TO LEGACY_FIELD, LEGACY_FILE TO LEGACY_FILE" but neither worked. I'm using this adodc to pass the information to a Data Grid.
Thanks

GaryCaspelich