Right Outer Join Record Updating Error

G

Guest

I've got a form whose Record Source is a query with a Contact table right
joined to a Vendor table. When editing a pre-existing Vendor for which the
Contact is not specified (Vendor.ContactID is null) if you try to type in any
of the Contact fields Access beeps at you and does nothing else. I mean, it
just beeps and there's no dialog box and no change in the form (Grrrr).

I've validated:
- I can enter a Vendor with Contact info when I'm creating a new record.
- I can change all the fields for a pre-existing record when the record was
created with Contact info (I think this point is important).
- When editing a pre-existing record without Contact info I can edit all
the Vendor fields.

There's a lot of ways to work around this, but it's a simple instance of an
error I'm seeing with other forms in my project. I've got one form that
allows Contract entry; and Contract can contain a lot of stuff and I'm trying
to avoid combining into one super-wide table.

I /think/ I'm seeing the same thing as Seth in the 10/25/05 post with the
subject "Record update issue".

One further rambling:
Opening the query directly presents the exact same behavior, with the same
unexplained beeping.

Vendor.VendorID and Contact.ContactID are both AutoNumber/PK fields.
Vendor.ContactID is a Number field with Required=No.

I've been beating my head over this for quite a while, asked others I work
with, and search Google and the newsgroups for a long time before posting.
Any help would be much appreciated.
 
M

Michael Cheng [MSFT]

Hi Jason,

I'd love to reproduce this on my side, is it possible for you to generate a
small sample and send it to me? Note that *.mdb file will be filtered by
our mail server and please remove the extension name instead.

I understood this might be sensitive to you. My direct email address is
(e-mail address removed) (please make sure you have removed ONLINE
before you click SEND) and I will keep secure.


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights
 
M

Michael Cheng [MSFT]

Hi

In some cases, you can edit the data in query Datasheet view to change the
data in the underlying table. In other cases, you can't. The following
table shows whether a query's results can be updated, and if not, whether
there is an alternative.

For queries that based on three or more tables in which there is a
many-to-one-to-many relationship. Though you can't update the data in the
query directly, you can update the data in a form or data access page based
on the query if the form's RecordsetType property is set to Dynaset
(Inconsistent Updates).

For more information, check the articles below

When can I update data from a query?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/htm
l/acconDeterminingWhenCanUpdateDataQueryS.asp

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top