What I need to do is have one base table containing all the current information for raw materials (item #s, cost, etc..) that gets updated every time we receive one of the items already in the table with new information. Like if the cost has increased since the last time it was received, I can change the cost for one specific item, then have it update every record that one item is used in. I have 2 subforms where that item would be used repeatedly for different finished products that are made up of that item. How can I have every record in every form updated whenever I make a change to that base table?????? :?: