Setting up a basic inventory
Hi. I'm fairly new to FMP and just got FMP 11. I'm trying to coordinate an inventory db I've created with a pre-existing invoice db. Basically, I can't figure out how to link the two files, and more importantly how to make the items sold in the invoices be taken out of the inventory file. I'm sure it's super basic, but I haven't been able to find instructions on how to do this anywhere, so any advice will be greatly appreciated.