Update field from subdata sheet.

S

sgbotsford

Database for orienteering controls (different control from access
control)


A control record can have zero or more clue records.
A clue record can have zero or more usage records.

So for relationships I have
Controls --one-to-many-->Clues--one-to-many-->Clueusage.

I want to make an update query that updates Controls!LastUsed with the
newest date in the appropriate ClueUsage record.
 
Top