taking information from 2 tables and inserting it into a third

[palsop]

Hi Guys hope you can help, just getting back into access after a long abscence and cant get my head around ADO

Here is my dbase structure

Table purchase_tbl
Id
Ponumber
Supplier
Date

Sub Table poitems_tbl (1 to Many to purchase_tbl)
Id
Lnktoponum
Item
Cost
Sellprice

Table stockitems
Ponumber
Supplier
Date
Item
Cost
Sellprice

I need to select each individual item from the 1st 2 tables and insert it into the 3rd table. I have done something like this before with an unbound form and filtered combo boxes, but cant find my old code.

The way is see it working would be Ponumber be selected from a combo, this would auto populate supplier and date. Selections from the sub table would be filtered to items only on that Ponumber. The user then selects the desired item and populates the other fields. This is then written to the stock items table by clicking a comman button.

Any help would be greatly appreciated.

Best regards

Paul