Access 2007 - Table/Form Help

[Guest]

I have a form that contains data from 5 different tables. When entering the
data in the form, not all of the sections (tables) are filled out. Thus, each
table contains a different number of entries. For some reason, my form
(containing data from all tables) only displays the entries where ALL the
tables have been filled out.

For example, the form contains Tables A, B, C, D, E.
Entry 1 contains information from Tables A, C, D
Entry 2 contains information from ALL tables
Entry 3 contains information from Table A

I want my form displaying all the entries, not just Entry 2.

What should I do???

Thank you.

 

[Guest]

You need to relate all the tables. You have to define a relationship or your
information will not be properly saved.