Hello Steven.
>> I am creating a cursor with a select statement. Several of my cursor columns are functions that scan a table based on the current cursor record info. Example: Field 1 is a drawing number. This drawing number can be associated with many Data Submittal Index Numbers which we call EDR's. The edr data info is in a seperate table.
>> In a given record I want to know the maximum date that a submittal was made on any affected EDR, who is responsible for this submittal, what is the EDR description, etc. The only way I know to get each one of these pieces of info into a column is to have funtions for each. This means the table is scaned over an over which makes it slow to generate the cursor. Please let me know if there is another way. <<
Assuming the EDR table has a field named "dSubmitted" and the main table is named "Drawing":
SELECT MAX(e1.dSubmitted), ;
d1.cDrawingID ;
FROM drawing AS d1 ;
LEFT JOIN edr AS e1 ON e1.iDrawingID = d1.iID ;
ORDER BY d1.cDrawingID ;
GROUP BY d1.cDrawingID
Brad Jones
Ariel Computing, Inc.