Need Help with form/query ...

M

Me

I want to create a form spanning three tables -
Let's call one table main and the other to sub tables.
The main table is connected to the other two sub tables with Project No.
The other two tables may have a record with the same Project No. or may not
have. So how can I create a form to do a Search where users should be able
to query data from either table on one screen.

Thank you in advance!
-Me
 
Top