On 9/29/19 12:40 PM, stan wrote:
> I have a table that consists of 3 columns.
>
> vendor_key
> mfg_key
> preferred (boolean)
>
> The idea is that a given vendor is the vendor we want to use for each
> manufacturer for a given project.
>
> I need to constrain such that only on row of mfg, vendor and project can
> be set to TRUE.
Where is the project id?
>
> I would be interested in seeing other peoples approaches on this, also.
>
> Any thoughts?
>
--
Adrian Klaver
adrian.klaver@aklaver.com