It is not clear here, but by two controls...do you mean two columns of
display, or is there in fact
two actual "grid" displays.
I *often* use two sub-forms to display "many" of the "one" side of a
relation on the left side of the screen,
and then on the right side show many for each of what is selected on the
left side.
Here is some screen shots of what I mean:
http://www.members.shaw.ca/AlbertKal...icles/Grid.htm
the above might give you some good ideas. The last screen shot is a classic
example of splitting out cheque funds for a given person to multiple
accounts.
However, if you want data from both tables to be shown on a single grid, the
build a query that joins the two tables together, and then build a continues
form based on that query.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com