Hi Guys,
Here's the long story shortened. I created a database with all sorts of tables and forms. My company makes marking machines and i wanted a database to manage the inventory of components for each of the machines. Here is what I want to be able to do.
Some of the machines have matching components so we order a number of them from our vendors for stock and they're used in 3 or 4 different assemblies. What I want to be able to do is, if someone updates a record in one of the machine component tables (lets say an electric motor) i'd like that same electric motor to be updated in the other tables as well.
So if someone tries to check stock on this motor they can see that we have the right amount of parts in stock and the correct value is displayed in all of the tables that contain this component. Currently, i just have this component (record) listed in all of my machine component tables that use this motor. 4 tables in all. And if I changed the QTY on 1 of the tables, the others would still stay the same.
SO is there anyway to link these records from all of these 4 tables to change whenever I change them in any of the tables?
I am fairly versed in VB and have a good amount of experience in Access with macros and other Build Events. Anyone got any ideas?? perhaps do I need to restructure the DB somehow? I would like to keep it so that if i open up the form which is bound to the same table to show all of the components for this machine and still have them linked somehow as i've explained earlier... It's a toughy I think.
Thanks for the help.
Tim