Subforms and scheduler

Subforms and scheduler

Hi

I have two forms, Form A and Form B.

Form A contains the details of a product and Form B as a subform.
Form B contains the name and email address of a person and a date.

I want to run a scheduled job which 3 weeks after the date on form B emails the person on form B.  However, the email must contain the relevant product information from Form A.  The problem I have is getting the relevant information from Form A.

Additional information:  Form B permits duplicate entries ie a person's details may be present 2+ times (this is need) in the Form B database with each instance being set against a different product.

I would really appreciate any support you can provide.

Thanks