Form from several tables

[Cesar]

Hello,
I need to create a form with data from 4 tables, which I previously created
the relashionship among them, I use the Wizard to create the form, alloing me
to select fields from any of my 4 tables, I finish and when I look at the new
Form in "Design Mode" all the fields picked during the Wizard are there, but
when I look at the new Form in "View Mode" nothing is shown!!, What am I
doing wrong?, Please help me on this,
Thanks in advance,

 

[John W. Vinson]

Hello,
I need to create a form with data from 4 tables, which I previously created
the relashionship among them, I use the Wizard to create the form, alloing me
to select fields from any of my 4 tables, I finish and when I look at the new
Form in "Design Mode" all the fields picked during the Wizard are there, but
when I look at the new Form in "View Mode" nothing is shown!!, What am I
doing wrong?, Please help me on this,
Thanks in advance,

It's usually not a good idea to create One Grand Master Query and base your
form on it, as you're seeing! If you use the default Inner Join you will see
only those records which already have data in all four tables; and most
four-table join queries will not be updateable. If a form is based on a query
with no records, and that query is not updatable, you'll see just a blank
form.

Instead, consider using a Form based on the "One" (or "one-est") table, with
Subforms based on the related tables. See some of the tutorials and examples
at:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials