General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Are you asking me if I would suggest one way of doing things, but in reality, do something else?? Of course not. Mark, you should know me better than that.
Granted, I don't use views. However, if I did and I needed to accomplish this task, I would do it this way....
That said, the suggestion I made is IMO, the correct way. You know, there is a reason why you can select multiple key fields for a table...
FWIW, it works just fine...
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only