Hi,i have organisational units (ou) within divisions. The name within the division should be unique.
ou: name=CHAR(80) divisionID=INT CONSTRAINT OperationalUnitDivisionID_FK REFERENCES division
These two attributes should be unique in combination.I only found many examples on how to make one attribute unique, but i guess this is a dumb newbie question - sorry.
As a side note: There never will be OUs nested within OUs. Thanks Malte
