Multiple PART_HANDLING_UNIT per Part Creates Multiple Order Lines

Hi all,

is there a way to make sure that there can be one and only one PART_HANDLING UNIT per Part?

Occasionally and accidentally two PART_HANDLING_UNITs are associated with a Part which ‘fans' the data we have in our Crystal Reports for either Sales Order or Purchase Orders reports.

-- SQL to fund duplicate PHUs:
SELECT PC.PART_NO PC_PART_NO, COUNT(*) Recs
FROM IFSAPP.PART_CATALOG PC, IFSAPP.PART_HANDLING_UNIT PHU
WHERE PC.PART_NO = PHU.PART_NO (+)
GROUP BY PC.PART_NO
HAVING COUNT(*) > 1
ORDER BY 1

Is there a way to enforce that one and only one PHU can be created per Part?

Thanks,

Craig.