Main form with subform and linked form???

[JimmyG]

I have a database that I use to track marketing efforts. Amongst others I have three tables; customers, contacts and marketing activities.

At the moment I have two separate forms, one form shows the customer details (the address, tel. number etc) with a subform containing the contact names for the company displayed. The second form shows the company name with a subform containing the various marketing campaigns relating to the customer. I need to use subforms as each company has several contacts and also will have several related marketing campaigns associated with them.

I would like to have my original form but with a linked form attached relating to the marketing activities data. I use wizards to create my forms from queries but the option for linked forms does not appear when my query contains three tables i.e. the customers, contacts and marketing activities table.

Is there anyway I could create the form I require??

Any advice is appreciated as always!

 

[Rob.Mills]

How do you mean linked? Do you mean you can open the 2nd form from the first with it located at the same company record as the 1st?