Complicated inventory question.....
I'm running FileMaker 11 on a Mac. Our databases were made on like FileMaker 4. I know really old. So each database is independent. I am, slowly and painstakingly trying to re-write our database so it is all inclusive on one database. I currently have our Orders and Inventory in the same database. I have had beginner and intermediate training. I am not sure how to script where when I put in a new order that it will automatically deduct the amount from our current inventory levels. Can someone help me with this or is this something to involved?? I'm really at a loss and really need the help.
There are several approaches that can be made to work for this. Here's a thread that discusses one such approach: