i have 3 files - each with different data on a group of people, all with an
ID number. I created relationships but now what? I need to combine them all
into one file. HELP PLEASE!

If all three have the same fields then use a union query.
If they have different fields then use a left join from the 'one' table to
the 'many' table.

If you need further assistance then post the table structure with field
names and datatype.

--
Build a little, test a little.


"Amy" wrote:

> i have 3 files - each with different data on a group of people, all with an
> ID number. I created relationships but now what? I need to combine them all
> into one file. HELP PLEASE!

Amy,

By three 3 files do you mean tables? Before you combine what are the fields
in those tables. A query may work for your needs but more information is
needed. Oh, and you might tell tell us what you are trying to do as it will
help us to give you a more precise answer.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Amy" <(E-Mail Removed)> wrote in message
news:B58CA719-A288-4799-9FDB-(E-Mail Removed)...
>i have 3 files - each with different data on a group of people, all with an
> ID number. I created relationships but now what? I need to combine them
> all
> into one file. HELP PLEASE!