gloringg

Hi,

Currently using VB 2008 with MS Access 2003.

I have Two Tables with Names - " Company_Data" & "User_Data" in which i have the following columns.....

Company_Data

Name|Age|Department|Salary

User_Data

Name|Age|Department|Updated On

Now, Is there any code that can do the following:

when i select a name in the combo box on the form (The list in the combo box is from the Name in the Company_Data table) and click update.

It should copy the Details of the Record from Company_Data to User_Data with the current date in "Updated on" column.

Please Note that the columns are not exactly Same. (Salary is not necessary in the User_Data)


Thanks for your help.

torpkevuk

It should copy the Details of the Record from Company_Data to User_Data with the current date in "Updated on" column.


do it using sql

insert into user_data
(field1, field2, field3)
SELECT field2, field3, field1, '1/18/2009'
FROM company_date
WHERE id = 'someid'

Roger_Wgnr

To start with having the same data in two tables shows poor database design.
Check out the links on data base design
Data Design
Just how normal ARE you ?

torpkevuk

i agree, it shows poor database design.. HOWEVER.. we dont always have the luxury of altering how an application works or was designed.. i know *I* have had to build a lot of applications around 3rd party software, or built on systems designed by my predecessors

So if you have total control, time and the willpower, redesign your database so you're not replicating data.. if not, then try my solution