Update multiple records based on most recent record

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

Guest

Is there a way to update multiple records based on the most recent record? I
have a table with several columns. The PK is always different, but everything
else should be the same. I'm looking for an easy way to update previous
records with the current information. Is this possible. I'm not great with
update queries, so if that's the way to go, can you please give me step by
step instructions??

Thanks!
Mary
 
Dear Mary:

Your statement is very vague regarding the specifics needed to begin to have
an understanding of your situation.

However, there is a principle of database construction you should plan to
follow.

If there is one or more values in "the most recent record" that are to be
associated with all the "previous records" then you should not be updating
those "previous records".

Instead, do not record those values in the "previous records" at all. If
there are sufficient relationships in the database to allow the "previous
records" with "the most recent record" then that relationship could be used,
not to update the "previous records", but to determine the current values
derived from "the most recent record" whenever it is needed.

The details of this are not clear, and it may not be easy for your to
visualize. If you clue me in better as to what your designs are, I may be
able to do a better job.

Tom Ellison
 
Back
Top