This is a slighly newbie design question, Is there anywhere in a database to store special information that's associated with the items in the database. eg I would love to store the order totals, special instructions, date, status of order etc. in the same database as the items of the order, instead of of having a separate database that stores these order summarys. Or storing the list of category names(not Palm categories, need a lot more than 16, stuff like "Sodas", "Tomato Ketchup") associated with a database of items. I held some hope for "AppInfoID" etc but realise that its designed specifically for Palm Categories.
Currently the only way I can think of accomplishing this is to use the 1st index (index 0) to store the information like OrderSummary then using the rest to actually store the items. I'd just add 1 to all incoming item requests so they skip the 0'th record and also set the comparison field of the 1st special record such that it is guaranteed to come 1st when being compared with DmFindSortPosition. I don't see why it wouldn't work but I'm just looking for other suggestions in case I'm still too bogged down in thinking like a DBMS : ) -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
