Hi to all and a good Wednesday ( Just barely as it is past 11 PM my local time )
If you want to kill al few minutes here is a way to whiley that away: Using the Daily Exercise Log database from monday's post, mine. What is the fewest number of actions using the Base UI ( an action being a mouse click or keystroke that performs a function ( typing in a name for a new item is one action) ) necessary to convert the flat single table to a simple relational model, and have all the current forms continue to work properly. To make it fair I'll define what that will look like. Currently there are six queries Query_<something>List being used to supply the selection items to 9 combo boxes on the forms DailyLog and DailyLog_Extra. Each query is a simple single field select from the column in the table assigned to the control. So, the list for Exercises is SELECT ExerciseType from ExerciseLog. So what I want to do create separate table for each of these lists. To make it simple - an entry for the contest will be...errr...quiz, no prizes here but bragging rights as they say. An entry should start with the assumption that the Base document has just been opened and the user is looking at the list of forms page. Then just count all the steps needed to convert one of those columns, and make the form work with the new table. Counting a right mouse click to get a menu and a left mouse click to select as two mouse clicks... For the sake of it, let's just forget the step about opening the relation deisnger and creating actual foreign key constraints. This is just the steps to define the new table and create it fill it with all the current values in the main table tell the forms to use that new table for the list items source So what is your entry, guess or hunch for the fewest steps, (mouse clicks and one step to entering a name), to do one column? A couple other questions: The form DailyLog_Extra has six combo boxes in two grids. When a new exercise is entered for a day how many of the combo boxes have their lists refreshed? How many when the 'Add New Date' button is clicked? What would one have to do to change the answers to the above questions? Could you? WEll, that is it for the Good Wednesday Pop Quiz.. thanks for reading along..now put on your thinking caps. My entrys...err.. answers tomorrow. Good Night ( just barely - not midnight yet.. ;-) Drew Jensen --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
