B was related to A, where multiple entries in B were related to one in A
C was related to A, where mutiple entries in C were related to one in A
D was supposed to be related so that when I changed from one entry in C to another, it would then change D. I also wanted it related to A, to prevent any possiblity that an entry in C could result in accessing the wrong entry in D.
If D is related only to C is that possible?
Also when I had D related to A, it seemed it would not change entries. B and C changed entries to reflect data that should only be filed under A. but D stayed the same as is it was independant of A.
I can not seem to get D to change so that:
"1 in A" = "Many in D" and "1 in C" = "Many in D"
Okay, step 1, give your database and tables MEANINGFUL names, if its classified information, use examples in a non context sort of way, that way people who read your post will know what you are saying... That... its WAAAAAAAY to confusing!!