Updating 2 tables from a single form

[jpm]

Hi Guys,



I am new to access.

1) I have a Access Table SPICES with list of spices e.g Cumin, Corriande, Chilli, Salt, Pepper, Bay leaves.
2) Another table SPICE MIXING to track how the spice mix are made e.g. Curry Powder is one entry and it will hold information in what ratio the above spices has been mixed.
3) I create a Form by Selecting SPICE MIXING Table ==> Create ==> Create Form to capture in what ratio the spices has been mixed. This Form appends the SPICE MIXING table. No problem till now.

Now since Curry Powder is a spice itself I want it to be appended to the SPICES table too as soon as the above form is submitted.

Any suggestions on how to do. Thanks in advance.



Regards
jpm

[ranman256]

tSPICES (feeds tMIXING)
salt
curry pwdr
pepper
cumin
chili pwdr


tMixing
-------
[batch],[spice], [parts]
salt, salt, 100
curry pwdr, pepper, 2
curry pwdr, salt, 2
curry pwdr, bay leaves, 1
curry pwdr, chili pwdr, 95
curry pwdr,