problems linking two tables together in forms

[Kevin Allen via AccessMonster.com]

I have two tables.
one is called opcincp. It houses each record info i.e. spec_no, cust_code,
etc.

The second, Permspec contains all the info for that spec. (spec_no,
constituents a,b,c.)

You can see they are both linked by spec_no.

In forms I want to show the entire opcincp table. When I click on a
opcincp record, I want the subform permspec to show the results
corresponding to that highlighted record.

I have tried many things and I cannot have all the opcincp record to show
at once.

 

[Andreas]

- Create the first form as a continous form.
- Create the second from as a continous form.
- Go to the first form and put a subform control into the form footer.
Use the wizard and set your linking field.
- The wizard will say you can't have the master form as a continous
form. Click OK. When you have finished setting with the wizard, go to
the form properties for the mainform and change the default view back to
continous form.

Regards,
Andreas