I think I need a relationship for this

[SpecialD]

Hi all,

I'm totally new to this, so bear with me.

Here is what I need to do:

When I create an invoice with parts from my inventory, I need the inventory to update the quanity to reflect that.

I have all the data in place, I just need to figure out the relationship between my quanity on the invoice and the quanity in my inventory.

Any help?

[Vaughan]

You'd better tell us how yopu have your data structured, because it makes a big difference.