Entering Information in different into different tables..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I'm trying to create a small application within Access. Every tutorial and
sample code that I can find is talking about the basic Entry Forms where you
can have a table bound form and every field is mapped to a column in the
table.

What I'm trying to find are some samples where the form contains information
from multiple tables and you'd have to enter the information using regular
sql statements. Can anyone please direct me to a tutorial or a preferrably
some sample code where I can see such things in action?

thanks
 
Farsad,
A form can use a query as the recordsource, as well as a table. In fact most forms are
"query" based.
You don't have to know SQL to join several related tables together in a query, and
present it to a form.
The Query Design grid allows you to "graphically" relate your tables, select your
fields, and criterias as necessary, while it "translates" the query into SQL for you.
 
Back
Top