Outer join problem

[Guest]

In developing a new file I've started to normalize the main table. But on
the form when a data entry attempt is made, the message "Cannot enter value
into blank field on 'one' side of outer join" shows up and the normalized
fields can't be updated.

Can anyone suggest why this is happening?

Thanks

 

[John W. Vinson]

In developing a new file I've started to normalize the main table. But on
the form when a data entry attempt is made, the message "Cannot enter value
into blank field on 'one' side of outer join" shows up and the normalized
fields can't be updated.

Can anyone suggest why this is happening?

Thanks

Probably because you're trying to enter data into an Outer Join query,
and you're trying to enter a value in the blank field of the outer
join.

Normally one would not enter data into an Outer Join query, but
instead use a Form based on the "one" side table with a Subform based
on the "many". What in fact is the structure of your tables, and how
are you trying to do this data entry - and why into an outer-join
query?

John W. Vinson [MVP]

 

[Guest]

Thanks John for the information. This is the first time I've tried to
"normalize" data fields - so, as expected, I've been struggling. I didn't
realize I had an outer join query. The structure of the tables is mostly one
large table with smaller ( 1 - 2 ) fields covering repeating data. The
database is a Nonconformance / Corrective / Preventive Action database for
manufactuirng - by it's nature - has a lot of fields. The entry screen is a
form and an autonumber is generated to provide a unique document number.
Right now you can populate all the required fields of a new record - but when
you go back and update a record the message I had stated earlier comes up.
So - it appears I'm stuck. The original table wasn't "normailzed" - that
happened after it was designed.

Sorry for the lateness of my reply.

Thanks

 

[John W. Vinson]

Thanks John for the information. This is the first time I've tried to
"normalize" data fields - so, as expected, I've been struggling. I didn't
realize I had an outer join query. The structure of the tables is mostly one
large table with smaller ( 1 - 2 ) fields covering repeating data. The
database is a Nonconformance / Corrective / Preventive Action database for
manufactuirng - by it's nature - has a lot of fields. The entry screen is a
form and an autonumber is generated to provide a unique document number.
Right now you can populate all the required fields of a new record - but when
you go back and update a record the message I had stated earlier comes up.
So - it appears I'm stuck. The original table wasn't "normailzed" - that
happened after it was designed.

It sounds like you've perhaps based this Form on a query joining one
or mor of your smaller tables. That's probably not the best idea;
instead, base the Form directly on your main table or on a Query
selecting and sorting records from your main table, and put Combo
Boxes on the form based on the lookup tables.

Without more information about your form and table structure it's hard
to be more specific...

John W. Vinson [MVP]