Creating a SubForm within a Subform within a Form

  • Thread starter Thread starter MaceagleFL
  • Start date Start date
M

MaceagleFL

I have three tables (Customers, Inquires, FollowUp Actions). I am
looking to create a form that contains all three. I want to be able to
select from a list (List 1) a customer and in a new list (List 2)
populates with information from the Inquiries Table based on the
customer I selected. Then a third list (List 3) populates with Followup
Actions based on the Inquiry I selected from list 2. I've tried using
wizards and doing it manually, but I just can't seem to get it done.
Any help would be appreciated.

Thanks,

Tony
(e-mail address removed)
 
Ensure that the Inquiries table has a FK linking back to the Customers table,
and that the Followup Actions table has a FL linking bak to the Inquiries
table. With this setting, the Wizard should be able to set your form with
the Customers table as your main form, the Inquiries table as the first
subform (showing all inquiries based on the selected cusomter), and the
FollupUp Actions (shopwing all Follup Actions based on the selected inquiry
record) as your second subform.

NWO :)
 
Back
Top