Querying with different tables

[Mike]

Hi All,

I have three tables (user,information,favorite)and each
table have their field
For user: username, age, etc...
For information: location,population,etc.
For favorite: kind of food, etc.

I created a query to get the record base on the users. The
query did fine with the first user because the fields for
the first user have completed information in each table.
But for the second user, it doesnt have any data in the
information table. The query took the first user's data
from the information table and displayed for the second
user. How can I solve this issue with the querying for
different tables??

Thanks for the help..

Mike

I created three tables I have a
query that will ask me for the user name and when I type
the user name, the form should display the information for
the particular user. Instead, I got a blank form with
nothing displayed. How can I solve this problem? I just
need to displayed the information base on the user when
entering it in the query.

 

[Brian]

Go back into the query builder and change the joins,
between the tables from matching to 'right joins'. If you
right click on the connection between the table, you'll
see (usually option 2) "All records from User and any
matching records from Information", for example. This
way, the query will give you all the information it has in
user and any records that match it from the other two
tables.

Hope this helps.

 

[Mike]

Brian,

Thanks for the help.

-----Original Message-----
Go back into the query builder and change the joins,
between the tables from matching to 'right joins'. If you
right click on the connection between the table, you'll
see (usually option 2) "All records from User and any
matching records from Information", for example. This
way, the query will give you all the information it has in
user and any records that match it from the other two
tables.

Hope this helps.

.