1 Reply Latest reply on Dec 5, 2008 2:30 PM by Chrisnta

    Linking databases

    mhalterman

      Title

      Linking databases

      Your post

      User forum,

       

      We've set up two separate files to track our inventory in the lab: one that tells us the actual location in our freezers of the various reagents we use (including a box view with 9x9 grids) and a second file that describes each reagent in detail (sequence, user notes, chemical formulae, etc.).  For the time being, we have been double keying for every reagent we add to the lab which is inefficient.  

       

      How can get these files to talk to one another so when we add or modify records the change will show up in the sister file?

        • 1. Re: Linking databases
          Chrisnta
            

          Hi,

           

          You could create a relationship between the 2 DB's. Use ID's to identify the records. Maybe ID's already exists which are identical in the 2 DB's. Like this:

           

          DB1                          DB2

          ID_Inventory   <-->    ID_Inventory

          Location_ID                Sequence

          etc.                          User Notes

                                         Formula 

                                         etc.