>I have a table that has six fields which hold IDs from the same table. Each field can have different IDs. Example:
>
>Contract Table:
>
>ContractID
>CustID1
>CustID2
>CustID3
>CustID4
>CustID5
>CustID6
>
>
>Customer Table:
>
>CustID
>First Name
>Last Name
>
>In the Contract table the CustIDx fields are all referencing the same Customer table. However, CustID1 will be different than CustID2, etc.

I was wondering why you have those six CustIDx fields. It suggests that your tables aren't normalized. Are there really exactly six customers associated with each contract?