Append query help

  • Thread starter Thread starter Bradley C. Hammerstrom
  • Start date Start date
B

Bradley C. Hammerstrom

Access2000

tblPhotos1: PhotoID, FileName
tblPhotos2: PhotoID, FileName
tblDesc1: Photo_ID, Description
tblDesc2: Photo_ID, Description

(Where Photo_ID is the foreign key)

The tables with tblPhotos1 was made first and Descriptions were added; then
more photos were cataloged and tblPhotos2 was created with a different
PhotoID sequence. Now I'm trying to copy Description records from tblDesc1
to tblDesc2 by keying on the FileNames in tblPhotos1 rather than the PhotoID
(since there is no longer a direct relation). How?

Brad H.
 
Hi,


Save your data ( make a copy, or a backup) and in a new query, bring the
four tables.

Join Photos1 with Desc1 through Photos1.PhotoID and Desc1.Photo_ID

Join Photos2 with Desc2 through Photos2.PhotoID and Desc2.Photo_ID

Join Photos1 with Photos2 through their common field name FileName. I
assume the file name of Photos1 are already in Photos2.


Change the select query type to a update query type. Update
Photos2.Description with Photos1.Description (from what I understand). That
should about it.


In this case, see the JOIN as the "path" we have to make the "look at"
to retrieve the Photos1.Description, required to update Photos2.Description.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top