Neat idea, but marginal in practice
They are a neat idea but of marginal utility in practice. Rules that require fields to be kept in synch (contraint or not) and fields that have to be updated in multiple tables require extra code that is often very awkward. Also, it makes multi-user problems even worse as it becomes easy to get part of two different peoples updates applied to the record.
They are handy sometimes for quick and dirty data entry or manipulation programs.
Of course, my experience with data aware controls is in VB and nothing in VB is elegant. It is possible that other systems have implemented them better.
Jay
