Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    300

    Red face Unanswered: Copy record to another table?

    I have two tables. One is a sales lead table and another a customer table. Both tables contain identical information with the exception of the SALES LEAD ID # and the CUSTOMER # [autonumber and key].

    I want a user to be able to click a button an make a SALES LEAD a CUSTOMER, so I want that record to be copied-- or moved to the CUSTOMER table.

    What is the best way to do this?

    THKS

  2. #2
    Join Date
    Nov 2003
    Posts
    300
    can anyone help here???

  3. #3
    Join Date
    Mar 2004
    Location
    belgium
    Posts
    290
    although I don´t use much sql, still learning about it here on this forum :-)).

    may be this is a solution :

    i think you have a form with the sales lead data in certain fields that has to be added to the customer table, opened as an recordset

    well try this

    rsCustomer.AddNew

    rsCustomer![field1] = me!field1
    ....
    ....

    rsCustomer.update

Posting Permissions

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