I'm wondering if anyone knows of a way to have identical data updated in several tables at the same time. The database work I do involves scientific information, and the layout implied by access does not lend itself to these applications. Basically, we've got 4 database tables, and we want to be able to have information in one table instantly updated in the other three for 10-15 fields to avoid having to type it all manually, and to avoid the increased chance of error caused by increased typing. I can get a pop-up list of all of the possible values, but I really want it to select a specific value based on specific criteria that will search and find a corresponding record. We can't have one single over-riding ID for all of these things, because in each table the fundamental identifier is different (in one case it's a test run number, in another a particle ID, in another a surface deformation ID, and the last is a sample preparation database).
I'd like to avoid dealing with creating forms/reports, and would prefer to simply deal with the data in the tables themselves, but I'm starting to get the impression that most of the more advanced data management features aren't available in tables (I'm a pretty new user, so I may be missing something terribly obvious).
Thanks in advance for any advice!
Dan Lundberg
I'd like to avoid dealing with creating forms/reports, and would prefer to simply deal with the data in the tables themselves, but I'm starting to get the impression that most of the more advanced data management features aren't available in tables (I'm a pretty new user, so I may be missing something terribly obvious).
Thanks in advance for any advice!
Dan Lundberg