I have a database that contains projects and each project contains many samples. I want a project level threshold value, to trigger highlighting when a field on the sample is above this threshold. I also want to be able to override the threshold at the individual sample level.
So I can see two ways to implement this:
keep the threshold field (only) on the sample, and trigger this to get filled in when the project is saved.
have both sample and project level threshold fields, and only use the sample field when it is relevant (there seems to be some redundancy with this model, though it more accurately represents the situation)?
Are there advantages / problems with either approach?