How can I get changes in Lookup table to be reflected in database?
I have a list of names and a score (Integer 1-100) for each, in my database. I also have a table with a letter grade that corresponds to each score from A to F. I have created a field in the main table with the letter grade for each name, which is a lookup from the score-to-letter table. But if I change the score-to-letter table (for example, have grade "B" start at a score of 85 rather than 89) this does not get updated in the database - I still see the old letter grade that was previously lookedup. I see that one solution is to reimport the entire list of names and scores, but this is a very awkward solution. Is there a better/cleaner way to make sure that I can change the scoring table as often as I like and have the database relfect the changes immediately?