May 23, 200817 yr Newbies Greetings! We have an access database we've been using to control inventory for years but are switching to FileMaker Pro this summer. Unfortunately I have no experience with the new program and am confused as to how I should go about setting up this database (amongnst many other things). I've always been told the best way to setup a serialized inventory system was to have two tables, one for incoming inventory (tbl_Inventory) and one for inventory sold (tbl_InventorySold). To check current inventory in Access I would run a query finding items in tbl_Inventory that were not matched in the tbl_InventorySold. How would I go about doing something like this in FileMaker? Perhaps more importantly, am I going about this all wrong?
Create an account or sign in to comment