Opening two Separate Databases

[TeeSee]

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

 

[Graham Mandeno]

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.