Updating records

[Guest]

Now, I have 2 tables which have same structure. (Firtname,Lastname).
In Table A: already has 20 records
In Table B: no record (because I just copied the only the structure from
Table A to table B). Recnetly, I have just put 1 recird for Table B.
How can I do to update automatically this record (table B) to tabel A?

Thanks for your help!

Cheers, Jason

 

[Granny Spitz via AccessMonster.com]

How can I do to update automatically this record (table B) to tabel A?

You can't do it automatically without a trigger, which Jet doesn't support.
You can have it occur when some form event happens, just execute an append
query like this:

INSERT INTO TableA
SELECT TableB.*
FROM TableA RIGHT JOIN TableB ON TableA.FirstName = TableB.FirstName AND
TableA.LastName = TableB.LastName
WHERE ISNULL(TableA.FirstName) AND ISNULL(TableA.LastName)

 

[Guest]

Hi Jason,

It depends on what you want to do. If you simply want to append (add) the
record from table B to table A, try this tutorial:

http://office.microsoft.com/en-au/assistance/HA011860631033.aspx

If you are looking to update the existing record in table A, from the record
in table B, that's a bit more challenging.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Well, I am a bit rush to put the question before I got the easy solution. Now
I can solve it already guys. I really appreciate your soon reply. Thanks
again

Ps: Your guys solutions help me to learn more things about Access.