Add data to 2 different databases w/1 form

[lipin]

Is it possible to update 2 tables, in separate dbs with the same form. I have two databases that have been doing two different things, but use basically the same info. I would like to update both with a common form that both can use. The fields are not exactly the same in both tables, But I was going to try to use some IF statements, like: if Hours = 8, in Hours Table of db1,
then Worked = yes in the WorkRecord table of db2.

Is this possible, and if so where do I tie the 2nd table to the form? Do I put it in the code of the form. Like if you put a number in the text box on the form, the code tell each table what to put in their fields based on the data on the form?

Please Help.

 

[afloyd]

I've had go the other way before (take from several dbs and put on one form) so I assume it is possible to go from one form to two dbs. I need to look up a couple things and I'll get back to you.

My first route would be to create a workspace, Dim the databases as objects and create ADO connections to them. Then you can assign values to the various tables using your IF..THEN statements.

HTH

-Al

 

[Dave Eyley]

Why not link the external table to the data base?

Open the main working db with the form, with nothing open but the database window - this should be set to TABLES tab.
Then go to the file Import option and select the other database and table.
The new table should show up with an arrow pointing inward.
It should be possible to use this table just like any other.
Any changes to this table will be made in the other db as well.

Good Luck....

 

[afloyd]

I used the link tables method on the application I developed. Sorry if I gave you bum advice about the ADO connection.