How do I merge two tables containing different fields

[Guest]

I have a database with two tables imbedded in a 'main' table. All tables are
related by a Unique ID Number. Each table contains different data related to
the Unique ID Number. I want to merge the two imbedded tables. There is
different data (fields) in each table, so I need to know the data is being
merged correctly.
Thanks for any help!!

Peace, Judy

 

[Randy]

I have a database with two tables imbedded in a 'main' table. All tables
are
related by a Unique ID Number. Each table contains different data related
to
the Unique ID Number. I want to merge the two imbedded tables. There is
different data (fields) in each table, so I need to know the data is being
merged correctly.
Thanks for any help!!

Peace, Judy

Judy, Create a new query, and select the tables in question. Then inner-join
the tables connecting their common fields (unless they aren't already).
Then, on the gird below, select the fields you want available for your new
table. Run the query (Query->Run) and see if that is exactly how you want
the new table too look like. If no, click on the design button to add or
delete fields or columns. Once you got the desire layout modify your query
to make a table query (by clicking on Query -> Make Table Query on the
menu). You will be prompt to enter the new table name. Then run the query
(Query->Run) and then you have a new table built from two different tables.

-Randy