Update Query Problem

[WtFudgE]

Here's the thing, I have a table with two medicine names, and a table with all ingredients, and a table with ingredients who are needed to make the medicine.
Now I have a form where I can select a medicine (in this case only 2 atm), and after i press the form button it shows all ingredients matched to this medicine, now if i enter an amount it should remove the matched ingredients amount times the amount given, in the stocklist. This all works except for one problem, if the ingredient i try to remove is also an ingredient of the other medicine, it removes this ingredient twice. So in case of many medicines, it removes the amount a lot more than it should. Please please pleeeeaaase tell me how i can fix this.
Here's a link to my database:
http://users.telenet.be/i_dislike_mushrooms/Cosdam.mdb

thanks a lot 4 replies

 

[Vassago]

Please do not double post.

 

[Keith Nichols]

Hi WtFudgE,

Without having thought about this too deeply, it sounds like a referential integrity problem. First up, I'd check the links between tables. It may be that you have a cascade delete that isn't required.

Mirriad posts on the subject on this forum. Use "Referential Integrity" in a search for further (and more informed) info.

Regards,

 

[WtFudgE]

I tried every possible relationship and I'm not getting any method which works