var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
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![field1] = me!field1