It's a long time since I last looked into database design and I've forgotten what I then learned (which did not include the answer to this).
Table Valuations records values that change quarterly. It is a summary of other values not used in the database. Each record has different values to all the other records, but I want to find a way to compare the Valuations values with a value that is the same for all records, but which also changes each quarter (but is the same for each record in Table Valuations.
I get the feeling a new table for the comparator is needed, but I can't work out how to link them and then thought maybe a global variable or global field would be better.
I'm stuck and would really appreciate some help.