[SQL 2000]Composite key (combination of PK from 2 tables) but allow null in the 2nd c

[GaryMazzone]

PKs can not contain NULL values, so Jmcilhinney is correct what you want to do is not possible. Not leaving a null in the second column of the key.