Allow null values in field

[AndySuk]

Hi Folks

I have a form which is based on a query which joins clients, Purchase Orders and Statements of Work.

The form is used to input Statements of Work as well as to view them. A ststement of work may or may not have a Purchase Order.

When I attempt to input a new Statement of Work Access won't save the record unless I have entered a a Purchase order Id. The POId is part of the Statement of Work table but it's not a required field. Access says that it can't find the key (of null) in the Purchase Order table. This is logical but I don't understand why it needs to as the PoId is a foreign key but not a required field in the Statement of Work table.

Thanks

 

[marleymanner1]

given the fact that it IS an Identification field itself, my guess would be that it is part of a relationship somewhere. that's probably what's throwing you off. NULL's can't be part of relationship fields...