Ugo DI LUCA Posted November 8, 2002 Share Posted November 8, 2002 You guys are driving me mad !! Any search to this forum or post I read makes me feel I'm wrong in the database I develop from two years... My concern is about Inventory. As it is built, my current Database use a single "PRODUCT BASE" for Product List and Inventory. I read in different post that most of those who deal with inventory created 2 specific Database. I must admit that this is the file that give me most concern, and that is why I never really made it work... For the moment, the number of Products in stock is weak, but we planned to develop our company and need a real Inventory tool. As this is my own business and that I personnaly develop this DB (at my lostime!!!), I would really appreciate any arguments on that matter (or maybe a alreadybuid cloned version), in order to...loose less time. What could be the problem with it ? Did some of you made it works like mine ? Thanks Link to comment Share on other sites More sharing options...
kennedy Posted November 9, 2002 Share Posted November 9, 2002 Are you only tracking the quantity in stock? If so, then a single database might be reasonable. However, if you are tracking each receipt of inventory and each disposal of inventory... then presumably you will have more than one receipt and disposal of each product. Keeping them all in the same database means that your product info would be repeated. That's bad. Whenever you have a variable N of something per 1 of something else... you need two files, not one. Do yourself a favor... go buy the Moyer/Bowers book "Advanced FileMaker Pro 5.5 Techniques for Developers"... it discusses relational design concepts... spend a weekend reading it and trying the examples they give... it'll save you weeks of heartache. Brian Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted November 10, 2002 Author Share Posted November 10, 2002 You are right... I spent this day reading a great part of the forum history...I feel desesperated. Do you know any Internet Site where I can buy it. I'm not sure I can find this book in France. Link to comment Share on other sites More sharing options...
kennedy Posted November 10, 2002 Share Posted November 10, 2002 Not sure how you're feeling ;^), but here's the publisher site: http://www.wordware.com/computer/filemaker.shtml They sell it online... don't know if they can sell outside the country, though. ISBN 1-55622-859-7 HTH. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7930 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