INSERT INTO "ItemInventoryAssemblyLine" ("Name", "IsActive", "SalesDesc", "IncomeAccountRefListID",
"COGSAccountRefListID", "AssetAccountRefListID",
"ItemInventoryAssemblyLnItemInventoryRefListID", "ItemInventoryAssemblyLnQuantity",
"FQSaveToCache")
VALUES ('NewAssembly1', 1, 'QODBC New Assembly1', '1B0000-933270542', '1E0000-933270542',
'60000-933270541', '5A0000-1197758364', 2.0, 1)

INSERT INTO "ItemInventoryAssemblyLine" ("Name", "IsActive", "SalesDesc", "IncomeAccountRefListID",
"COGSAccountRefListID", "AssetAccountRefListID",
"ItemInventoryAssemblyLnItemInventoryRefListID", "ItemInventoryAssemblyLnQuantity",
"FQSaveToCache")
VALUES ('NewAssembly1', 1, 'QODBC New Assembly1', '1B0000-933270542', '1E0000-933270542',
'60000-933270541', '5B0000-1197761433', 1.0, 0)

and the result looks like this in QuickBooks 2006:

See also: Trying to update ItemInventoryAssemblyLine table 

This seems to work for adding multiple items (ItemInventoryAssemblyLine records) to an assembly when the assembly is first created.

However I am having trouble adding new ItemInventoryAssemblyLine records to an existing assembly. When I try to repeat an INSERT with FQSaveToCache set to 0, then I get an error

QODBC Error 3100 - The name "NewAssembly1" of the list element is already in use (#10053)

any help on this will be greatly appreciated!

regards

Mike

I don't think we can add items to an existing assembly. The workaround would be to create a new assembly with the additional items.