Re: Not in List Event Error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I cannot see where I may have posted this, as it would not have been true.
My apologies for any misunderstandings. Thanks again for your willingness
to help.



"AccessVandal via AccessMonster.com" <u18947@uwe> wrote in message
news:8dc0241e1a08c@xxxxxx
In my database, the city table is the one and the
vendors is the many.

Now, this was a contradiction on what you wrote earlier. Somewhere in your
previous post you said that the Cities table, where one Vendor may include
many City ID. Did you edit it?

They are linked in tbl_Vendors on City_ID and do have RI and
cascade update.

It's because you said that the user could choose City IDs. That's why I
had
to assume the Cities table was the child table.

My apologies if I misunderstood your table structure. Perhaps, if you had
compact and repair as suggested in my first post.


Edward wrote:
Thanks. Perhaps you misunderstood what I posted, but what I posted does
in
fact support one-to-many relationships. The problem lies with a corrupted
database, not with the relationship structure. FYI, I have read up on RI.
I teach it, and have for many years. I'm not accusing anyone, and I
apologize if it came across that way. I'm saying that what you offered as
a
solution was not correct. In my database, the city table is the one and
the
vendors is the many. I'm simply using the vendors as vehicle to update
the
one side, which is possible.

Best regards

--
Please Rate the posting if helps you

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1



.

Relevant Pages