queries and subforms ??

[Guest_imported]

I have
Clients(ClientID, firstname,lastname......)
Policy(PolicyID, ClientID, Company, Series.......)
2 main types of policies
Investment(PolicyID, Inceptiopn units,lumpsum, monthlysum..)
Insurance(PolicyID,Inception premium, Preminum type..)
Clients and policies are one to many relationship
Policy-Investment and policy-Insurance are 1 to 1 with referential integrity enforced.

This is where the problem is, a client can have many policies and the info of the resp policies are stored in the respective type(insurance/investment) tables.
In my policy display form i have a subform which displays some fields of the policy table in a datasheet type view for a particular client.
i want the form so that if i want to see the details of the particular policy, then i will double click on the particular policy record and then the info will be extracted frm the investment or insurance table and be displayed in a form.

how do i do this ? if i design a query, how do i make the query extract info from 2 diff tables and display it in a diff form ? any other sugggestions ??

 

[landShark]

check out the microsoft pivot table active-x control.