Opening two Separate Databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TeeSee - 28 May 2008 01:10 GMT

I have two DB's ... one has item, customer type tables used for
pricing and keeping track of which items a specific customer buys etc.
The "MaterialMaster" table contains a field named MSDS.

The second table is purely a list of items or groups of items for
which we have to have MSDS's on file for as well as keeping track of
the dates they require to be renewed etc.Since this encompasses
"groups" of items there are no item codes assigned to them.

When adding a new item to my "MaterialMaster" table throo a form I
would like to access the MSDS database to open Allen Brownes lookup
routine to find the appropriate MSDS file number.

Could someone please advise how I might go about this? Thanks as
always

MSDS is Material Safety Data Sheet

Reply to this Message

Graham Mandeno - 28 May 2008 02:43 GMT

Hi TeeSee

Do you really mean that you have two separate *databases* or do you mean two
separate *tables* within the same database?

If it is the latter, then you simply create a relationship between the
primary key field of the MSDS table and the MSDS field of the MaterialMaster
table. No lookup code is required because Access will do it all for you.
Your form that is used to edit the MaterialMaster table would contain a
combo box bound to the MSDS field, with its RowSource based on the MSDS
table. This would allow you to select the correct MSDS in a simple and
friendly way.

If the MSDS table really is in a separate database, then add it as a linked
table in your main database. Then you can proceed as above.

Signature

Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

>I have two DB's ... one has item, customer type tables used for
> pricing and keeping track of which items a specific customer buys etc.
[quoted text clipped - 13 lines]
>
> MSDS is Material Safety Data Sheet

Reply to this Message