Re: Not in List Event Error

Well, I’ll leave it to you to do what ever you want to do with your database.


I would suggest you read up more on RI before you accuse someone. I’m not
saying you can’t have one to many with RI. As according to the details you
have given, it’s a one to one relationship not possible to have a one to many.


Edward wrote:
With all respect, that is incorrect.

RI simply prevents you from deleting the data from a parent table when there
are related records in child tables. The cascade update is simply a smaller
override that allows for automatic refreshing of the child tables without
having to systematically refreshing each field where the reference is found.
Cascade delete overrides the safeties and allows for the deletions of the
child tables' records first before removing the primary record in the parent
table.

In reality, one to one relationships are rare, but they do exist. Many to
many are almost non-existent, and I think IF you get a many-to-many it is
probably because of bad database design. I think the same about one-to-one
relationships UNLESS there are special circumstances where they are needed.
In all of my years of programming, only one program required tables based on
one-to-one relationships. If the database is normalized correctly, the most
common WILL be the one to many relationships. I know because I've been
using this structure for years, and I teach this at the college level. I'm
one of those who actually programs in fourth normal form and sometimes
fifth, depending on the way that the table structure is needed.

Like I said before, I have been updating records in a one-to-many
relationship for years without incident, which is the nomal way of
programming. This same code works fine with unbound tables and to some
degree with the bound table, but it is simply going to another record, which
it shouldn't. I am now leaning toward a corrupt table, which I've seen
Access do before.

In the future, I would appreciate it if you would please refrain from
writing as an expert if you truly are not aware of correct data structure.
While I appreciate your enthusiam to offer assistance, your advice for the
RI is absolutely incorrect on the basis of a one-to-one relationship, and
had I been a programming novice, your advice would have had me chasing down
trails that were incorrect. If your table structures are one-to-one, then
may I suggest that you revist them and evalutate whether or not they have
been normalized correctly.

If you want to maintain RI, you must use one to one relationship. You can't
use one to many. To maintain RI, a child record cannot be an orphan. It
[quoted text clipped - 35 lines]
both bound and unbound forms has the underlying recordset pulling
from tbl_cities.

--
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

  • Re: Not in List Event Error
    ... In my database, the city table is the one and the ... are related records in child tables. ... In all of my years of programming, only one program required tables based ... I am now leaning toward a corrupt table, ...
    (microsoft.public.access.formscoding)
  • Re: Theres got to be a better way
    ... I work with annoyingly complex database tables whose structure ... Programming is all about reinventing the wheel. ... But we're still writing code must like we did 40 years ago. ...
    (comp.lang.php)
  • Re: Theres got to be a better way
    ... I work with annoyingly complex database tables whose structure ... changes as my client changes their requirements, ... Instead of repeatedly writing code to format output from the DB, ... Programming is all about reinventing the wheel. ...
    (comp.lang.php)
  • Re: Theres got to be a better way
    ... I work with annoyingly complex database tables whose structure ... changes as my client changes their requirements, ... Instead of repeatedly writing code to format output from the DB, ... ALways with programming it's bread and butter, ...
    (comp.lang.php)
  • Re: What is .net
    ... software) for installing and running ASP.NET desktop applications and Web ... You just want to learn, and have no experience programming (nothing ... relational database design in general and SQL Server in particular. ... don't ignore the topic of "relational database design" - ...
    (microsoft.public.dotnet.academic)
Quantcast