displaying form data from 2 tables

C

Clayton

have received two databases from a client wanting them to
be merged and become one database, they are DHA life and
DHA, is there an easier way of doing this as I have been
battling for weeks and get problem after problem, one
problem is, I imported all tables, reports,quaries and
forms into the DHA database, and joined the tables
Clients and clients table by ClientId which is an
autonumber, but when i try and display the data from both
tables on one form it will only display the data from the
Clients table, table
..
 
J

John Nurick

Hi Clayton,

Do the two databases contain information about the same clients, or
different clients? If the same clients, which information is correct?
 
J

John Vinson

have received two databases from a client wanting them to
be merged and become one database, they are DHA life and
DHA, is there an easier way of doing this as I have been
battling for weeks and get problem after problem, one
problem is, I imported all tables, reports,quaries and
forms into the DHA database, and joined the tables
Clients and clients table by ClientId which is an
autonumber, but when i try and display the data from both
tables on one form it will only display the data from the
Clients table, table
.

Clayton,

Take a deep breath. Reread this message from the point of view of
someone who has never seen your database, doesn't know what "DHA"
means, or anything about the structure of your data.

A bit hard to even figure out what you're asking, no?

Please describe the nature of your tables, what their primary keys
are, and what you have tried in the Queries. I'm sure we can advise
but we'll need to understand your data a bit better in order to do so!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top