I have a form with two subforms on it. the form contains project info and the first subform is about invoices. projects have multiple invoices and from those invoices there are multiple drafts. so i have a project filter on the main form and from ther i have an invoice filter on the invoice form. this all works until i try to filter drafts from their particular invoice. Here is the record source stuff for the unbound draft filter:
SELECT draftnum FROM draft WHERE draft.invoicenum=forms!invoice!invoicenum;
what would be the child parent link? could that be a problem because now i have it set to invoicenum for the draft subform.
Thank you for all the help!!!