I have the following table: EmployeeInformation
Fields ,EmployeeInformationID ,Essentia_ID ,ADP_ID ,SSN ,FirstName ,LastName ,SupervisorOrVP ,LocationNum ,Primary ,EmployeeActive ,RecordActive ,CreatedBy ,CreateDate ,ModifiedBy ,ModifiedDate
Each employee can have only one EmployeeInformationID but can have multiple ADP_IDs. (I inherited DB).
So ADP_ID is unique but EmployeeInformationID is not. However 1 record should be marked as primary.
I need to validate that each employee record has at least one record marked as primary.
This will be done inside a frequently used program before i do some calculations and create other records in other tables.
What is a good way to do this?