Here's a good one...

[fiveshorts]

Can I make a "dynamic" value list?

I'm building a solution that tracks a trader's transactions and which 'suggests' the size of the next trade based on various risk thresholds. Would it possible to translate that 'suggestion' (the result of a simple calculation) into a "capped" value list that actually leaves out any values that are greater than the suggestion?

Real world example:

Trade A: Risk represents 50% of risk threshold.

Trade B: Remaining 50% of threshold translates to suggested trade size of '5x'

Trade size value list available in record corresponding to Trade B runs in 0.1x increments up to (but no greater than) 5x, so trader cannot actually log a trade greater than the suggested size.

Hmmmmm....

[Fenton]

I don't really know much about what you're talking about. But if you've got a number on one side of a relationship (it can be unstored), then you can target another number, and use the less than or equal to operator ≤ to limit the target records.