keep old record name, but change current name

[bbcwjun]

any ideas how I can keep an old record (ie. video history with video name and video #) but when I change a video name, the old record's video name also changes? How can I keep the old video name (video # doesn't change) because it points to the new video name when I get a new tape?? Again to explain it maybe easier... i have a table that stores the rental history (ie. video #, video name) but I also have a choice of changing just the video name if I get new tapes. The rental history points to this new name also but I want it to keep the old name so the customer can see whether they have seen the video before?

Thanks!

 

[K9Boxer]

One option is to store the 'Video Name' on the customer record instead of always pulling the Video name as a result of a join.

Another option would be to add another key field: Video#, Video Assign Date (date name assigned to the number), Video Name. When selecting a video for a customer, the video number and video date will be stored on the customer record. This complicates the logic of entering a Video #, because the value stored would have to be the most current Video Assign Date.

Just some thoughts..... others?