Look Up Table Data - retaining the previous value in the core table

[Yoplumpy]

Hi All - hope you can help with this one.

I have my db with various lookups set up which is working fine. It's just that in the future someone may want to tweak an existing value. I am using Access 2007.

I have found that it I edit the lookup data it immediately shows in all the records it's been used for.

Is there a way to stop this from happening as a value may be valid one year but the tweaked value may be appropriate the next.

I could get users to edit the old and create a new value but just wondered if there was a way to do it without that. I am sure I haven't had this problem before!

Any help would be gratefully received.

Cheers

Paul

 

[Galaxiom]

This is how lookup tables work. If you haven't had the problem before either you have not used lookups or the users have not edited the values yet.

Don't allow users to change existing values. If they want a new one then they should add it to the list. It is easy enough to provide a form for them to do this.

I alway include a field in the lookup table to indicate which records are currently available so obsolete ones are not shown.

To deal with exiting values the combo or listbox row source must have the value from the current record added to those in the lookup table.