>>Or you can completely skip the views and go directly for cursoradapter, which does all of that but more openly, and much more under your control, so you can do whatever you want on any of before* or after* events (qv in help for CA).
>
>Lately I've been thawing to the idea of using GUIDs for PKs. Makes it easier to consolidate databases from multiple sites, or do consolidated reporting. Even if the customer originally swore up and down they would never need that ;)
Just today I remembered a similar story... about 25 years ago we were writing a water billing app in Hungary. It was one of those things they said will never happen: "you calculate the amout as per the price for the month", and we said "what if the price changes during the month?", "that will never happen". Of course it happened within the year. Hungary had only about 30% inflation at the time, and we were just fresh out of earning our collective doctorships on the subject. Should have placed a bet.