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?
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:
ID_Inventory <--> ID_Inventory
etc. User Notes