index/primary cannot contain null value

[BinHDreW]

Hi all,



i was wondering if anyone could help me or point me in the right direction?!

I have a feeling my solution is quite simple, I've tried different variations for relationships and still get the same error. I cant figure it out for the life of me

Okay, I'm creating a database to record students receive funding for school support. A student can have access to the following:

• Individual or school based support (one to many) "Program Type table"
  
• each "Program Type" (individual / school based) can have 1provider in the program.

This is what my database looks like... (see attachments)

For the third image, i would like to be able to select another program type (e.g. school based) and make a new record but i keep on getting the error.

I've also included my relationship table as well.

Any type of help will be appreciated greatly!

thanks all.

Andrew

[June7]

This is form/subform arrangement. Do you have the Master/Child link properties correctly set in the subform container control?