Updating Table Via Form

[ansentry]

If you open the attached sample db you will see that I have a cascading combo box (It is working fine).

The data for the tables that are the source for the combo box are imported from an excel sheet.(This works fine)

Now my problem the data from excel is variable after the data is imported into access I want to add to it items from another table.

After the data is imported into both tblModel and TblParts I want to append to tblParts each item from tblFixed for every Model.

If you open tblPartsEXAMPLE you will see what I want to do (I added this manually).

I hope that my expanation is clear and someone can offer some advice.

Thank you in advance.

 

[lanato]

you can see the new Query:qryInsertFixed
is that you want?

 

[ansentry]

lanato,


Yes, Thank you.