2 Replies Latest reply on May 25, 2012 2:33 AM by MartinMcDermott

    How can I get changes in Lookup table to be reflected in database?

    MartinMcDermott

      Title

      How can I get changes in Lookup table to be reflected in database?

      Post

      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?

      Many thanks