Re: [dba-users] Example database

[Andrew Jensen]

Frank Schönheit - Sun Microsystems Germany wrote: Hi Marc, Doing both, making self contained application examples from real life and internally using a list of things to show (access user: how does this work in OO.o-base?) could be o good thing. Knitting this with the idea mentioned elsewhere in the thread: We could then have an online help section collection all those "How do I do ..." questions, which refer to the sample database, and explain how the actual problem is solved therein .. OK, can we start a collection of such questions. A couple of items that come to mind, right off the top of my head are: How do I open a form from another form? ( Button click, menu item ) How do I filter a result set based on a value from a drop down list box? How can I use a combo box to select values, but allow the user to update the list of available choices? How to add a sub form to a sub form? How to display a summary ( aggregate ) field for all the records in a table grid control, that updaes when records are added or updated? How to set up a field that displays a calculated value based on the entry from other controls? ( display only & how to save this value ) How would I use a value entered in a control to update  a batch of records in the database? How to limit ( alter ) the list displayed in a list box when an item is selected in another list box? How do I display values from more then one column in a list ( combo ) box? How do I programmatically copy a record's data to a new record, allwoing for some columns to be changed before being written? I will go ahead and scan the Base thread at the Forum and see if can find others that get asked time and again? If folks send others via this list I could compile them all into a document and make it available at my web site for review. Drew