Transfer specific data from one database to another

[Swarv]

All,

I have an issues form in a database (MS Daily log) and when you fill in the form it save the data into an issues table. Everytime you do this it gives each issue an ID number (auto number).
Basically I want to fill in the form then before clicking next I would put another button on the form and when clicked it copied the data I just added to a table in another database (Helpdesk Log). The I can click next and goto the next record and carry on.

Any ideas please as its driving me mad.

Thanks

MArtin

[dickersonka]

why not use a trigger?

[Swarv]

how do you mean?

[dickersonka]

whenever the insert happens on your table, in sql server you can create a trigger that can insert into another table for you

http://www.4guysfromrolla.com/webtech/091901-1.shtml

if thats not what you are meaning, try to give a more clear explanation

[Swarv]

it is kind of. I dont want every entry I make into the form to be copied across to 2 databases. I want it so that I can choose after I fill in the form whether I want to copy to to the other database or not. Thanks

[dickersonka]

ok then, what are you having trouble with and what language is your form in?

[Swarv]

the form is just an access form and im doing the whole database in access 2003.
Does my first post above help?
Thanks

[dickersonka]

i would suggest to post in the access forum then

also what trouble are you having? you can't insert into your database then another database as well?

[Swarv]

I can insert into the database the form is on but its the copying that record then to the other database

[mrugeshm]

Hi all ,

i need help transfer data from one database to another databse, by using query in vb.net application. help me here to solve this problem

mrugesh