Quote Originally Posted by Murmandamus View Post
Actually, I'd like to amend that a bit. IF you are using a database engine which supports update-able views, and your view meets the constraints the engine places on such views (like all fields present and a one-to-one relationship between the view and all the constituent tables, for example), then you *may* be able to accomplish it with one insert without using the trigger trick.

Now, whether Delphi 2010 supports that via its database components, I am not sure (I don't own 2010, so can't speak to it). However, it is a pointless exercise if your database engine doesn't support it.

Edit: Just as a sample, here are MySQL's restrictions on update-able views

Thanks for responding!!

Apparently, I also need help with the Insert SQL being new to all of this. I appreciate the site example but to be quite honest, it was above my head. I was told that inserting into multiple tables requires a join. I'm looking into this also.