Hi guys,

I have been having this problem for many applications and can't seem to figure out a great way around it.

Lets say I have a table called Minutes I have another table called AgendaItem

Minutes -|--< AgendaItem

How should I write the interface when a person adds a new Minutes record, they can also add multiple agenda items to the minutes record? I want to be able to do this in one step and if they decide to cancel mid way, it will not write any new agenda items.

Heres what I do now.

Display Minutes

User clicks on a Minutes record

it shows a list of all the agenda items

user clicks agenda items to update.

Does anyone have a good way to do this smoothly?

Thanks!!

One way of doing this would be to use transactions. I am sure that there will be several, some to your expectations, but the functionality that you mention - all or nothing - will be handled by wraping your inserts/updates in a transaction.