I would create a view for the Notes table and update both the Orders and Notes view inside a transaction.

---

>I have a table (orders) that I create a view from that has all records with orders.approved=.f. From this view
>I change orders.approved to .t.. However during the approval I want to add notes to the order. The notes
>table is in a one to many relationship with orders.
>
>orders.id -> notes.id
> notes.message
> notes.id
> notes.message
> notes.id
> notes.message
>
>Since notes is not part of the initial view (there are no notes to start with) what is the best way
>to get the notes into the notes table? I could create a transaction and insert the notes right into
>the notes table but that seems sloppy since I am using a view. How would you pros do it?