José,
I was afraid that the solution I came to, and that you use too, namely do all the checking in the programming, would be the only workable.
I find this very dissapointing cause all the functionallity that the VFP database offers, becomes useless (maybe a little bit to strong ??), and again we come to a situation that the database can contain errors, due to errors in one or another program.
I'm wondering what other UT members think about this and how they handle the verification of data ...