On 8/25/06, Richard Dillman <[EMAIL PROTECTED]> wrote: > > ... > I definately see where a cCounty Coordinator will be county wide but a > Training Coordinator could be at the city level so based on zipcode but > not > in every county.
Man, I love databases. Really you want to try to nail down this stuff using some ESP. If you are up on the content yourself (& internal workflow, etc.), you will be able to make some decisions that will simplify things down the road. Like, they'll say, "County Coords do x and y" and "Training Coords do w and x", and forget to tell you that some "people" are both training coords AND county coords, so if you haven't thought about that possibility before-hand... it's harder. Recon. as much as possible before you even start wanking with table structs or user interfaces. Ask lots of Qs. The more you know, the less you work. Maybe. At any rate, here the zips span counties, so zips and couties are totally different, as far as a "service area"... e.g. zip != county nor vice versa. Sometimes it does, of course, but only sometimes. What I've done in the past is have a zip field, with a "lookup" button next to it that pulls the counties for that zip. You just need to be sure there is a clear difference between a county that is part of an address, and a county that is a "service area" or whatever. Or zipcode, if that's the service area. Bah. That paragraph made a ton of sense. Should be 3 pages or so, prolly. ;-) Stuff like this is where AJAX really shines... I used pop-up windows and JS back in the day, but I'd do it in a little DIV in a heartbeat now. Oh I love a slick UI, yes I do. But I like it all, really. Even cryptic, green-on-black... Could I make any less sense? Yeeeowzers. Well, hope it somehow helps. Can't see how, but, hey, I'll send it anywayz. :D ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
