Results 1 to 3 of 3

Thread: inserting records ibto multiple tables

  1. #1
    Join Date
    Dec 2002
    South Africa

    Question inserting records ibto multiple tables

    I need help, i have got a form that has multiple checkboxes, option buttons and textboxes.

    I need to be able to pass their values to multiple tables in a accsess database, i dont know if i have to use a query.

    Please help.

  2. #2
    Join Date
    Dec 2002


    Well, you can certainly use query to update the tables. for Maintaining point you should have the values first and then use query/Recordset per table to update them. My personal choice is to use insert/update query.
    Vishal Gupta

  3. #3
    Join Date
    Dec 2002
    Originally posted by Dave Clark
    A note seems required here. Using SQL still creates a recordset object. Your reply seemed to be worded as if using a query would avoid having to create a recordset object. This is not true and I just wanted to make that clear.
    However, it is true that this is much more obvious when one is retrieving data with SQL (SELECT) -- rather than when one is just using an UPDATE or INSERT query.
    I wrote use Insert/Update query to update the tables. By this way there will be no need to use Recordset object at all. Here purpose was to update the tables, so i don't find any point in creating the recordset object with table locking and high state of cursor. Simple things should have been done by simple way. Don't you think so.?
    Vishal Gupta

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center