I ran into a mapping problem

the original structure i decided to use had complicated mapping and i ended up entangled in it.
so i went back dropped all the tables and rewrote the structure scratch up so now it is a linear mapping rather than many to one mapping