Originally Posted by
jwaes
@orange .. not necessarily the lowest price.
@ArviLaanemets .. Ok, i was hoping i could do it with some sort of unique key or so, but it looks i ll have to code it. Thanks
Why code - to enforce a choice? I see 2 examples of suitable table design so you must not be referring to that. Consider a ranking rather than a simple boolean since you will have multiple supplier records for the same product, why not rank them as 1, 2 or 3 so that user knows which is next in line if #1 can't provide?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.