can I create a form with record source from more than one tables

  • Thread starter Thread starter aboalex
  • Start date Start date
A

aboalex

I would like to create a form with two pages ( a pop up one) that contain
controls from different two tables , can this be done please advice.
 
On Sun, 29 Mar 2009 10:05:01 -0700, aboalex

The data will be readonly if the underlying query is non-updatable.
Two tables typically means one-to-many; if that is the case a parent
form / subform combination is the way to go. If these are two
unrelated tables, I would still consider one or two subforms.

-Tom.
Microsoft Access MVP
 
Back
Top