I
iksrobyzrp
Guest
I want to implement a system where my Next Actions are rows in a relational database, one that I can carry around in my Treo 600.
Fields will be: Action, Context, Project, ActionDate, etc.
At least three advantages: 1) separate action lists (i.e., @phone, @store) not necessary: simply run parameter query on Context field; 2) separate tickler system not necessary: simply run query on ActionDate<=Today ...incubating items filter out and become visible only on/after their ActionDate; 3) find all of a project's Next Actions by running a parameter query on Project field.
Questions: (1) any advice on structuring this system, from those of you who have set it up this way ? (2) I am new to PDAs...any of you ready to help me get an Access-esque DB onto my Treo?
Fields will be: Action, Context, Project, ActionDate, etc.
At least three advantages: 1) separate action lists (i.e., @phone, @store) not necessary: simply run parameter query on Context field; 2) separate tickler system not necessary: simply run query on ActionDate<=Today ...incubating items filter out and become visible only on/after their ActionDate; 3) find all of a project's Next Actions by running a parameter query on Project field.
Questions: (1) any advice on structuring this system, from those of you who have set it up this way ? (2) I am new to PDAs...any of you ready to help me get an Access-esque DB onto my Treo?