How do I create a form based on a multi-table query?

[Guest]

We've created a query based on 6 tables. I want to create a form based on the
query that will allow me to populate the tables.
However, when we go into form view to enter data the fields in the form are
not visible, it is blank.

Has anyone created a form based on a multi-table query without this problem?

 

[Allen Browne]

You are unlikely to get this to work.

The most obvious reason why the query would return no records is that the
default gives you inner joins. For more on this and criteria with nulls,
see:
The Query Lost My Records
at:
http://allenbrowne.com/casu-02.html

After you solve that, so the query returns records, the query will probably
not be updatable (or at least most of it fields will not be), so you will
not be able to use it to enter into all 6 tables at once.

You need a different design, which will involve a different data structure,
a different interface (separate forms and subforms for the various tables),
or both.

 

[Guest]

Wow! Thanks Allen!
I will go to the link and read the article.
We will probably use subforms. Again, Thanks for the help.
TBIII