Here is the issue that I am trying to solve. Basically in Access you can create subforms, I am trying to so the same thine... for example
Form 1 client inserts details
Form 2 Client insert one or many products as per order.
then when they finished adding all the products they hit the main submit button which adds the data to the separate tables
Using UD4 on a iis4 server, any help here would be great.... As you can tell justing learning

HI,
Submitting to multiple tables at once is tricky business. I found this shopping cart extension which has a feature that handles this and is worth looking at: www.thechocolatestore.com/ultradev/

This saved me alot of time and headaches and is worth the money, or maybe download the free simple cart (if they still do it) and just work it out from the code provided in that? Hope it helps.