Populating fields in another DB

[Dazza666]

Hi,

is it possible to create records and populate fields in another database automatically, we have to very different databases that serve two very different purposes and we would like one to be able to update the other, for example when someone adds a client on a database a corresponding record is made on the other and certain information is populated (name, National insurance Number etc.). We need this to work cross table, almost like linking the database at the field level not the table level.

thanks

 

[DCrake]

Then why can't you link the master table from the Host mdb to the supporting mdb?

This will give you the opportunity of adding a record from either mdb.

 

[Dazza666]

Then why can't you link the master table from the Host mdb to the supporting mdb?

This will give you the opportunity of adding a record from either mdb.

the problem is that both DB's are developed and have their respective fields, we're after a quick way of just associating certain fields with one and other

thanks

 

[The_Doc_Man]

DCrake DID give you the quick answer.

The quickest way is to link the target table from database A into the database B that needs to do the updating. I.e. Database B contains an external table pointing into a table in an MDB file that is database A. Just update the table in B as though it were resident in B. Let JET figure it out for you. (It can and it will.)