Append new data into Both Parent and Child (1 Viewer)

[GPGeorge]

It gives no one any pleasure to have to point out the flaws in a design over which someone has labored for considerable time. Yet, it happens over and over. Creating a useable relational database application does require more than good intentions. As The_Doc_Man -- and others -- have noted, the best time to correct a problem is always right now.

 

[mounty76]

I don't see an issue with the design, just not sure you're fully understanding the needs of the DB as a whole. The Doc man said after seeing the relational diagram that he sees nothing wrong with the design. It works well without any issues.

I had an issue with the Subscription table. I have it working now with two append queries.

 

[GPGeorge]

What he actually said is "Your post of your relationship diagram crossed with my response. I see nothing wrong with that diagram."

That does not imply the overall design is adequate. In fact, the problem is in the way the Subscription table is set up.

Show us the ENTIRE relationship diagram for all tables, if you would please.

 

[mounty76]

The fundamentals of the DB are good, it was the subscription table that wasn't correct. I've amended this now and it is all working fine, thanks for everyone's input as always.