Difference between revisions of "OOOForum posts and associated databases"
|Line 56:||Line 56:|
Revision as of 06:57, 14 June 2006
What follows is just a description of items on my machine. The screen shots are of forms that I created as examples for people on the OOOForum. The database files they use are my own creation as are any associated basic libraries.
One good thing about this motly group is this. Almost always when building these examples I used tables created with the Base wizard. I had hoped that this would allow me at some point to re-use much of the work done on the forms (Reports), queries and or macros. In reviewing the files, it appears that this will be the case.
A second thing is that each form, or groups of forms, or basic procedures actually implements most of the functionality for some business function. Keep in mind these where all written as examples, not work for hire, so lots of the bells and whistles are missing. Error handling for one, there isn't much. But even so, there is a lot to be used as a leg up for this project.
As for the basic libraries. I have routines for a tickler function. This has the computer prompt for when to contact customers based on a period, which period is adjustable by the type of customer, or individual customers. It is also a great candidate for using QiQ instead of the view that is currently used.
Data import and merge functions - A set of procedures to import a text file into a schema. The routines use the TEXT table feature of HSQL to import the data. To name two.
Contact / Customer management. This was a database created to help show how one might manage a many to many table relationship. It used 2 data entry forms and later a dialog as a splash screen. Later still I added a search form.
Order / invoice generation
Order Head ( New Order Screen ) [ Route sales company ]