Someone please help me!

[Guest]

I really need some help and I'm on a serious time crunch. 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?

 

[Guest]

Is the form that asks for a job number bound to a field on the main form or
is it an unbound field on a popup (or sub form) that is different to the form
the you are trying to "fill-in" the fields.

Are all the fields (includeing the "ask for a job number" field) based on
the same table - query.

Can you let us have some more details

 

[Guest]

There are two tables which are joined in a query. When opened a parameter
box pops up asking for the 'job number'. There are four fields being used
from the first table(this is the information which is populated) and the rest
are from the second table. All fields are bound and all are based on the
same query. I must tell you I am not good at writing the code, I'm still
using Access the old fashioned way, with the commands that are offered, plus
it's Access 97.

 

[Guest]

You are trying to update a foreign field without the record being linked to a
field in the primary table. (You can't enter apples, pears, etc without
fruit being one of the categories). And in you case you can't enter
information for a job that does not exist (in the main/primary table )

Make sure the Primary Key field is shown in the query

Check the referential integrity of the joins on the relationships page.

Also when you have time check this link on the MS site

http://support.microsoft.com/?scid=kb;en-us;304473&spid=2509&sid=216

 

[Guest]

Thank you

You are trying to update a foreign field without the record being linked to a
field in the primary table. (You can't enter apples, pears, etc without
fruit being one of the categories). And in you case you can't enter
information for a job that does not exist (in the main/primary table )

Make sure the Primary Key field is shown in the query

Check the referential integrity of the joins on the relationships page.

Also when you have time check this link on the MS site

http://support.microsoft.com/?scid=kb;en-us;304473&spid=2509&sid=216

 

[John Vinson]

There are two tables which are joined in a query. When opened a parameter
box pops up asking for the 'job number'. There are four fields being used
from the first table(this is the information which is populated) and the rest
are from the second table. All fields are bound and all are based on the
same query. I must tell you I am not good at writing the code, I'm still
using Access the old fashioned way, with the commands that are offered, plus
it's Access 97.

PLease open the Query in SQL view and post it here. It sounds like the
error lies within the query (at least in part).

Remember... we're volunteers here, not sorcerers. We *cannot see your
database*. We don't know the structure of your query or of your form.

Typically, if you have two tables to update, you'll be better off
using a Form for the "one" side table of the relationship and a
Subform for the "many", using the primary key and the corresponding
foreign key field as the Master and Child Link Fields respectively.

John W. Vinson[MVP]