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?