Open a table from another database and displaying results

[mafhobb]

I need some insight on how to do this.

I have two independent databases for two different groups of people. One is regarding product development (PD) and the other product support (PS). Both of them have a table with info based on SKU number (for example ABCD1234).

I am trying to find out how to create a button in the PD database, that basically opens a table in the PS database so that the development people (people working on the PD database) can see the calls that the Product Support people (people working on the PS database) are taking on a particular SKU number.

Generally the Product Development people (PD db) use a search tool to find and open the form containing the data for the SKU number they are looking for. The button would be placed somewhere in this form and once clicked, it would look for the SKU# value in that form and then open the table in the other database that containing the call log for the matching SKU#.

Any suggestions?

mafhobb

 

[mafhobb]

I forgot to add that the PD people will never have to edit any information in the PS database. This is purely about viewing the data, nothing else.

 

[Extra_Cover]

Why not Link the required tables?

 

[mafhobb]

"Link"?

Sorry, but I have limited experience with this.

Could you give me an example/explain what you are talking about?

Thanks

mafhobb

 

[Mike375]

Go to File and Get External Data and Link and take it from there.

After linking the table name will appear in your data base with an arrow next to it. It can then be opened like the other tables.

 

[mafhobb]

I'll give it a try. Thanks!

 

[mafhobb]

I'll give it a try. Thanks!