<i><font color="#663300"> As most of you know, I've been pretty busy the last few months. But it looks like over the next few weeks I may be able to find some time to add something that the framework has sorely needed: a sample application.
I'm thinking about a typical inventory management app. Think of a warehouse filled with stuff, some of which have discreet serial numbers, and others which are just parts. There would also be "assemblies", which consist of one or more of each of the two kinds of stuff mentioned. There would also have to be some sort of catalog, which would represent the orderable items. These orderable items could be either individual parts, or they could be assemblies. Those of you who have read <b>Data Model Patterns</b> by David C. Hay (ISBN: 0-932633-29-3) will recognize this as the typical Inventory and Structure parts of his "Things of the Enterprise" chapter. BTW, this is an excellent book - every database developer should have it!
I'm not sure what the app would be able to do beyond taking an order, determining if sufficient inventory exists, and then adjusting the inventory to reflect the shipped items. Here's where I need your help. If you have any ideas about what would make this useful as a learning tool for beginning Codebook developers, please reply to this message with your thoughts.
I also plan on keeping a "journal" of the steps I take in creating the app, so that I might write an updated step-by-step guide. This assumes, of course, that I can somehow find the time to do all this... <b>;-)</b></font></i>
Thanks for the great idea, what I would like to suggest is that you can also get the Client name from the Clients Master and check against the credit limit for the order and only then proceed for the transaction.
As a new user I would want to develop atleast such a basic tranaction system where there is one transaction dbf with child records containing multiple items and the transaction will be dependent on the details from Clients and Items master for confirmation of continuing with the transcation.
I for one will immensely benefit from this effort of yours as I am not able to explore sufficently and in speed due to other commitments. Thanks you for thinking in such a helpful manner for new users.
Regards
Bhavbhuti
©2001 Bhavbhuti Nathwani |
