Newbies Jmosey Posted May 23, 2008 Newbies Posted May 23, 2008 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?
Recommended Posts
This topic is 6087 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now