FIGURE E


Change the first column to reflect the journal entry category. Roll over picture for a larger image.

The first thing to change is the view name. In the properties box, change Copy of ($All) to By Category. Below that, remove the ($All) alias. Just leave the alias blank. Now look at the view itself. It has three columns. The first has no title; it's a narrow column. The second column is the journal entry title and the third, Modifed, is the date the journal entry was last modified. Click once on the column header of the first, narrow column. In the lower pane, you'll see three radio buttons: Simple Function, Field, and Formula. Click the Field button. You'll then see a list of fields. Select Categories from the list. You have just a few more changes to make in the column properties box. We're interested in just the first two tabs of the properties box, Basics and Sorting. Change the column properties to match those in Figure F.

FIGURE F


Configure the column to match these properties. Roll over picture for a larger image.

You can now close the properties box, and save and close the new By Category view. Your Journal database is now Palm device friendly. Any categorized Palm Memo Pad memos should now show up categorized in the Journal when you look at the By Category view. Likewise, if you create a journal entry and categorize it, the category will show up in the Palm Pilot Memo Pad. If you decide you don't like the new Journal database, or for any reason want to go back to the original Journal design, undoing your changes is simple. Go into the Journal database and select Database->Replace Design from the File menu. Select Personal Journal from the template list and click the Replace button. Finally, delete By Category from your list of views. You're back to square one. Happy HotSync!

Tom Lowery is an Applications Analyst for The J. M. Smucker Company. He holds an M.S. in Computer Science from Kent State University and is an R4 Principal Application Developer and R4 Principal System Administrator. His favorite hobby is playing with his one-year-old son Duncan, who is now walking and will soon be able to outrun his dad. Tom can be reached at tom@lowery.net.