Adding commodities to supplier record

I recently build a databse of suppliers which works fine and stores the
relevant data ok. My problem is now that we have about 10,000 parts that are
supplied by about 5,000 suppliers and I'd like to allocate the right part to
the right supplier.
I have the full 10,000 parts in one table with part no; description; father
id (the part list is hierarchal) and would like to select the part from a
combo list and save it to a list, which also needs to be updatable (other
parts added and deleted as necessary).
Can anyone offer some tips or advice as I'm finding this part a bit
difficult to build.

PS I am a beginner/intermediate at VBA