displaying form data from 2 tables

  • Thread starter Thread starter Clayton
  • Start date Start date
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
..
 
Hi Clayton,

Do the two databases contain information about the same clients, or
different clients? If the same clients, which information is correct?
 
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
.
Click to expand...

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!
 
Back
Top