Add an associated item to an order automatically (1 Viewer)

[PeterOC]

Hello,
I'm working on a database very similar to an order processing screen.

You select a product code - add amounts and various other details.

There are products within the database that have other 'sub-products' linked to them. I'm trying to work out a mechanism whereby when one of these products is added to the order the sub-product also gets added.

I've set up a table that links the product code with the sub products.

Any suggestions on what is the best way to do this?

Thanks,
Peter