Matt, Am I correct in saying that you can't use the category functions if a record belongs in more than one category? (In my example, I might have a customer that gets a delivery on Mon and Wed).
In my example, I wanted to make each day of the week a category (representing a delivery day). I wanted the user to select a day of the week from a category list (e.g. Sun, Mon, Tues, Wed...), and then I would display the customers getting deliveries for that day. (But we have customers that have get more than one delivery per week).
I've never used categories myself but based on your example, I'd suggest splitting into 2 dbs. One is a delivery table, which has the day of the delivery and then links to the customer in the second table which holds the customers just once.
/* * Matt Graham * Palm OS Developer * www.healthramp.com */
-- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
