Really missing something. When you have a database with say, six tables that are all related, I figured the best way to work with the information is to create views of each. Having trouble when you want to add a record to the parent table (which then also needs to add a record to all the child tables). I am Inserting Into the view that comes from the primary/parent table. Do I also need to insert to all the child views? Bottom line, what is the best way to add a record to the Parent table and all the related child tables?
"Live Well, Laugh Often, Love Much..."