send data from one database to another (1 Viewer)

[bbwolff]

i have two databases, both have mysql backened and access frontend.
In first database, I'd like to access the second database, check if that person has an entry in the second database and then fetch that data into the first database. To make it easier, data come from different tables (though I'd probably access only one entry in each table)

Not sure where to start, the only idea I have is to link tables from both databases into the frontend ad then it's kinda easy (would have to rename the tables).

 

[GinaWhipp]

Sounds to me like you have two identical databses and the bigger question would be why? But... to answer your question, just do the linking, it's quick, easy and solves the problem.