Help again!

[Candace]

I really need some help. I've set up a form that asks for a job number, then
pulls up that record. I need to be able to type in the empty fields located
on this form. When I try to enter data into the other fields I get an error
that states that I can't enter value into blank field on 'one' side of join.
Does anyone know how to do this?

 

[Jeff Boyce]

Candace

It sounds like your form could be based on a query that joins tables in a
one:many relationship. A more common "forms" way to do this would be to use
a main form for the "one" side, and a subform to display all the related
"many" records.

Regards

Jeff Boyce
Microsoft Office/Access MVP