Linking to Different Database

[joesmithf1]

Hi Everyone,

I have two completely different databases(dbsA and dbsB). In a form of one of the database(dbsA), I want to be able to click on a button to 'query' information from dbsB. Is this possible? Is there anything that I need to set up on the 'front-end' or can i do this with scripts?

Please help.

Thank you.

 

[KeithG]

Link the table from dbB to dbA.

 

[joesmithf1]

Thank you. This sounds easy, but how? I don't see the table of the other database(dbsB) when I am in Query design view of dbsA.