General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only