AnsweredAssumed Answered

Should I use some kind of variable or a new table?

Question asked by basilisk2 on Jul 27, 2018
Latest reply on Jul 27, 2018 by wimdecorte

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.