2005. augusztus 13., szombat

How to iterate through both a master and a detail table


My tables need to have master-detail relationship, but I still want to iterate through all the records in a table (detail...). My tables are:

Associate- employee name, leads, supervisor, etc...
Quality Score- associate name, etc...
Productivity Score- associate name, etc...

Obviously, these will be linked via the associate name. However, I cannot programmatically iterate through all the records after being linked. What I want to do is get the average quality score, productivity score, etc... for the team lead and supervisor. Any ideas?


You can do something like:

{ ... }
while not MasterTable.EOF do
  while not DetailTable.EOF do
    { do your stuff }

Nincsenek megjegyzések:

Megjegyzés küldése