Bringing 2 table together in a query

Thanks everyone - the append query worked super - and I can run this
from a macro (i presume) so it is a lot easier for a user to set up
their database.

Once again excellent advice - thanks for the time and effort you put
into helping us all.

Uzytkownik "keri" napisal w wiadomosci
ups.com...
Hi,

I have a strong feeling this is a simple question, but I have been on
this computer so long my brain has fried!

I want to bring 2 tables together in a query. Both tables (these store
records of appointments made) have the same fields - one has data that
is imported from Excel, and one has data inputted from a form in my db.
(In case you are wondering for a couple of reasons I cannot import my
data from excel directly into the same table that my form entries will
go into). Therefore when users want to view all of the appointments
they have made they currently have to go to 2 seperate tables - one for
old data (imported) and one for new data (entered via the db).

The problem is when i come to create relationships I can't seem to
understand how to correctly do it. The primary key in the new table is
the APPID - an autonumber - in the imported table it is the same field
but not an autonumber. The Name, AppDate and all other fields on both
tables may be duplicated between tables, and in each table on its own.

How do I do this? Please tell me if I am being very dumb!

Hi Jan,

"(In case you are wondering for a couple of reasons I cannot import my
data from excel directly into the same table that my form entries will
go into). Therefore when users want to view all of the appointments
they have made they currently have to go to 2 seperate tables - one for
old data (imported) and one for new data (entered via the db)."


Instead of thinking about importing data directly into the table,
consider appending data TO the table from the table that you did import...

it is NOT a good idea to have redundant structures in a database. There
are several things you can do to keep track of what came from where...


Warm Regards,
Crystal
*
(: have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Jan Kowalski wrote:
Uzytkownik "keri" napisal w wiadomosci
ups.com...
Hi,

I have a strong feeling this is a simple question, but I have been on
this computer so long my brain has fried!

I want to bring 2 tables together in a query. Both tables (these store
records of appointments made) have the same fields - one has data that
is imported from Excel, and one has data inputted from a form in my db.
(In case you are wondering for a couple of reasons I cannot import my
data from excel directly into the same table that my form entries will
go into). Therefore when users want to view all of the appointments
they have made they currently have to go to 2 seperate tables - one for
old data (imported) and one for new data (entered via the db).

The problem is when i come to create relationships I can't seem to
understand how to correctly do it. The primary key in the new table is
the APPID - an autonumber - in the imported table it is the same field
but not an autonumber. The Name, AppDate and all other fields on both
tables may be duplicated between tables, and in each table on its own.

How do I do this? Please tell me if I am being very dumb!