locked
Need Example of Insert SQL Statement with Access DB RRS feed

  • Question

  • User1772043685 posted

    Hey All,


    I can't believe I am asking for this, but I am.

    It has been over 18 months since I have created any type of form that had to submit to a relational Access DB.

    I am looking for a working example to refresh my memory on how to use a form to submit an order request using a relational database and access data source and asp.net controls in vb.

    Just FYI my tables are listed below.


    Customers:CustID,Name,Email,Phone

    Orders:OrderID,CustID,

    Orders_Items:OrderID,ItemsID

    Items:ItemsID,ItemDesc

    Quantity:Quantity (this table will populate dropdown for users to choose a quantity of 1-?


    Any help appreciated to get me thinking again.

    Regards,

    TRU

    Wednesday, September 29, 2010 8:28 AM

Answers

All replies