help! related table doesnt update :(

[DonLduk]

Hello.

I have this problem. Please refer to this small picture.

http://www.geocities.com/luiguibanez/help1.jpg


The details_MNN table relates to the details_AA14 and details_IR21 tables with the field MNN.

In the subforms that I have, when you create a new MNN entry for the details_MNN table,that new MNN field is autoupdating or auto-creating (as it should) in the AA14 table but NOT in the IR21 table.

As you can see, all the relations are set correctly, and in the subforms when you move through the differents MNN in the details_MNN both AA14 and IR21 tables cycle equally. The problem is the auto-update for the IR21. (yes I have checked the 3 fields in the relations integral reference, update and delete fields)

Could anybody help me figure this out so the IR21 table autoupdates as well? it must be a simple solution as it works for one table already.

Thank you very much for your time

 

[namliam]

Even with Referencial integrity on I dont think the database will create a dummy/empty record if it doesn need to.

Ref Int serves to prevent orphaning, i.e. removing a parent record when a child is still present. Not to create a child when the parent is created.

 

[DonLduk]

thanks for the reply.

Yes effectly the database wont create something that it doesnt need.

I just figured out the problem. I thought that just by adding a new MNN it would be added to their childs, but it is not added UNTIL another field for the child table is filled, in this case, after I fill a "date" for IR21, the MNN in the details_IR21 will be added, which then will allow me to create more child from that.

im bulding a family tree here! eheheh thanks for the help.

 

[missinglinq]

As Mailman said, Referential Integrity is like odd numbered avenues in New York City, all one-way!