Null Value in a Table?

C

Carla

I created a set of tables for a basic project for a class in Access
2007. It is telling me when I try to enter data that a field can't
contain null value. I'm inputting data - how can I figure out what
field is giving me this problem and why?

I established many to one relationships.

It is a project to use to make purchase order forms and reports.
 
C

Carla

DId you perhaps set the field's Required property to Yes?

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)








- Show quoted text -
Click to expand...

Would it matter if I entered information in every field? It's pretty
simplistic - pono, podate, supplierid, supplier name, supplier
address, inventoryid, qty ordered, description, cost. The PONo is
automatically generated and that's generating fine.

I'll look, tho, but I am entering information in every field. I went
into the various tables and entered supplier records and inventory
records so that there would be information to pull up.

Thanks
 
C

Carla

DId you perhaps set the field's Required property to Yes?

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)








- Show quoted text -
Click to expand...

Can't find the "Required" Property in the property sheet.
 
C

Carla

Can't find the "Required" Property in the property sheet.
Click to expand...

Figured it out! The concatenated tables that I had set up were set up
with two primary keys. Once I removed the primary key setups from
them and recreated the relationships, entering data worked.
 
Top