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??
Thanks!

Do a little research on cascade updates and setting referential integrity in relationships.