Record Insert with multiple tables

V

Vanessa

I have a master table and a detail table. I am using seperate views to enter
into each and things appear to be fine. The problem I'm having is when I
enter a new master record. It writes to the database fine, but it creates a
record in the detail table. When I'm testing the delete of a record in the
master table for a record it won't allow it because of the blank record
(blank being all other fields but the primary keys) in the detail table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top