Difference between revisions of "OOOForum posts and associated databases"
DrewJensen (Talk | contribs) |
DrewJensen (Talk | contribs) (→Screen Shots) |
||
| Line 21: | Line 21: | ||
| − | [[Image: | + | [[Image:Prjctcnt_3.png]] |
''This form is designed to be used by other forms, functions and includes a set of basic macros to be used to update its contents for display and to exchange data with the caller.'' | ''This form is designed to be used by other forms, functions and includes a set of basic macros to be used to update its contents for display and to exchange data with the caller.'' | ||
Revision as of 06:56, 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.
Screen Shots
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.
This form is designed to be used by other forms, functions and includes a set of basic macros to be used to update its contents for display and to exchange data with the caller.
Order / invoice generation
Order Head ( New Order Screen ) [ Route sales company ]
Order Detail ( Order Line Items ) [ Route sales company ]
Order Entry Screen ( Gift Shop – so lots of different shipping vs Billing addresses )
Store Layaway Screen [ Thrift Store ]
Inventory Adjustment Screen
Invoice form as Calc template file.
Misc.
