Question Multiple updates

[stucky]

Hi All,
I am probably thinking too much about the way to solve this but any suggestions appreciated.
One item can have many updates and one update can update many items.
i currently have two - one to many relationships with a bridge table.
When a user selects multiple items (tick boxes) the update table is updated (one update record) and the bridging table is appended with the amount of items selected. I do not want to update the items table as I do not think this is necessary.
Sorry for the long post.

 

[pbaldy]

Is this appropriate?

http://www.baldyweb.com/MultiselectAppend.htm

 

[stucky]

Hi Paul,
Thank you for your prompt response. It is indeed what I am trying to achieve and gives me something to work with. Thank you, much appreciated.

 

[pbaldy]

Happy to help.