transfering data between tables

  • Thread starter Thread starter mel
  • Start date Start date
M

mel

I have two tables, CUSTOMER & ENTRYTABLE. The CUSTNO
field is the primary key & the foreign key in the former
and latter. I want to know if it is possible when data is
entered into ENTRYTABLE can the data be automatically
entered into CUSTOMER. Both tables have the same fields.
Thank you.

mel
 
Hi Mel

You can copy data from one table to another with a SQL "insert onto"
statement (aka an append query).

But I fail to see why you would want to automatically duplicate data in two
tables.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.
 
I have two tables, CUSTOMER & ENTRYTABLE. The CUSTNO
field is the primary key & the foreign key in the former
and latter. I want to know if it is possible when data is
entered into ENTRYTABLE can the data be automatically
entered into CUSTOMER. Both tables have the same fields.
Thank you.
Click to expand...

If both tables have the same fields - YOU'RE MISSING THE POINT.

A relational database follows the "Grandmother's Pantry Principle": "a
place - ONE place! - for everything, everything in its place".

Storing data redundantly is neither necessary nor desirable. Each
table should contain fields pertaining to its own "entity" (person,
thing or event); i.e. your Customer table should have information
about the customer, and that information should not exist in *any
other table*.

What's the purpose of Entrytable? Why do you feel that you need two
identical tables?
 
Back
Top