I've read through the forums and tutorials but not sure what i'm looking for. I created a parts database with access 2000. I've got a table for inventory, parts out, parts in, and switchboard. I created forms for each as well. The switchboard works nice like i want it to. Whenever I take a part from my shop, I want to enter it in parts out and have it taken from inventory table/form. Like a live update or calculation. That is that part I'm stuck on.I'm not sure if I need to establish a formula or a relationship somewhere. Any help or suggestions. Thanks guys.