having trouble setting composit primary key

[itm]

Hi,
I am trying to set a primary key on two fields. the problem is that the one field is null for some records. they will eventualy fill them in. However, because it is null now it will nowt let me set it as a primary key. I tryed setting the feild, in the properties, with a default value; but it would not tkae it. Any ideas would be reall appreciated.
thank you
itm

[John_G]

A composite primary key can never contain Null values in any part of it - so you cannot do what you are trying. This make sense - because a primary key must be unique, allowing part of a composite PK to be null would lead to problems with duplicate values.

A default value in the field properties only specifies the value that the field will have when new records are entered - it has no effect on existing records.

John

[itm]

Thank you I was hoping that there was a was y to put a default vaule in, but I quess not .
Thanks