e 2 tuhave 2 tables,similar structures, how do I update 1 from ot

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables in a database with similar structure. Each share 2 fields in
common. I would like to link the tables so data entry in one is captured by
the other. None of the queries or relationships I have tried work - Update,
Append query types and the various optiond in Relationships. I am fairly new
to Access and am using 2003 version.
 
On Tue, 16 May 2006 12:51:01 -0700, Jim B <Jim
I have 2 tables in a database with similar structure. Each share 2 fields in
common. I would like to link the tables so data entry in one is captured by
the other. None of the queries or relationships I have tried work - Update,
Append query types and the various optiond in Relationships. I am fairly new
to Access and am using 2003 version.
Click to expand...

Are you trying to store the SAME data in two different places?

If so... DON'T.

Storing data redundantly is essentially NEVER a good idea. Could you
describe these tables and what they contain?

John W. Vinson[MVP]
 
John,

Appreciate your response

My two tables are in a lottery record and analysis system. The two tables
are for the power ball five numbers and the second table is for the power
ball number. in both tables I have the drawing date and powerblaal number
plus other fields. I enter the date and powerball number in the first table
and want to copy them into the second table for further analysis, frequency
etc. In Dbase IV it was easy and straight forwsrd, but at some new edition of
Windows I probably won't be able to use Dbase.
 
John,

Appreciate your response

My two tables are in a lottery record and analysis system. The two tables
are for the power ball five numbers and the second table is for the power
ball number. in both tables I have the drawing date and powerblaal number
plus other fields. I enter the date and powerball number in the first table
and want to copy them into the second table for further analysis, frequency
etc. In Dbase IV it was easy and straight forwsrd, but at some new edition of
Windows I probably won't be able to use Dbase.
Click to expand...

You can create a Query joining the two tables. I realise that in DBase
you're used to creating a new table whenever you want to do much of
anything - but that is not necessary in Access.

You can use a Query as the basis of a Report, of a Form, to export
data, as the basis for another query - basically ANYTHING that can be
done with a table can be done with a query.

If you think that you need to copy data into the second table in order
to do analysis - reexamine this assumption, since it's *wrong*.

John W. Vinson[MVP]
 
Back
Top