Sorry, first post with no topic.
Given 3 tables:
---------------
Table Operations(Op)
Op_ID, Op_Name,...
and
Table TravelerHEADER(TravH)
TravH_ID, TravName, Part_ID,...
and
Table TravelerDETAIL(TravD)
TravD_ID, TravH_ID, Op_ID, TravOrder,...
How can I retrieve the OP RecordSet
associated with the subset of TravD records
given a single TravH_ID?
That is to say:
There are a finite set of travd records that relate to a singular travh record... for each of those travd records I want the related Op record.
Stumped again,
Brian