relate form to subform

R

Raul Sousa

Hello all.
I have a tableA with several fields. One of them is jobid.
I have a tableB with several fields. One of them is clientid.
I have a tableC connecting tableA and tableB. tableC as two fields; jobid
and clientid.
I have a relation between tableA.jobid and tableC.jobid and another relation
between tableB.clientid and tableC.clientid.
I need a form based on tableA with a subform based on tableB. Every jobid
must have a clientid.
Who can I connect this two tables in one form. Any help is most welcome.
 
Top