Just curious. Would you really do it this way? While logically I know this should work, I just don't think I could put enough faith in a view like this to use tableupdate and hope all the records in the
group by get updated. Just me personally, if I need fields from a group of records updated with the same values, I would go with the UPDATE SQL command.
>Make sure that all three fields are available in your view. Further, make sure that all three fields are checked as the key fields in the update tab of the view designer...
>
>HTH.....
>
>
>>I have a GROUPed view and when I update a field, I want the update to happen in all the related detail records. The uniqueness is a combination of 3 fields. I tried several combinations of keys, but I either get too many records updated or only one.
>>
>>Any help would be appreciated. Thanks
Mark McCasland
Midlothian, TX USA