Hello,
i had similar issues in my brain when i did my first database design.
well that was long time back.
I am no expert in this subject to give u suggestions.
well I can be a fall back mode, if no suggestions got then u can safely use mine.
Now Yes ADDT really wont directly help u in multiple linked tables..
u need to sit and think a strategy of how users will interact with ur web interface.
1.> yes anything that repeats we keep in separate table.
2.> we link it with some unique key to its parent/master/ whatever....
sometimes we do self links.
now ur question about handling mutiple tables links..
it gets not so easy with plain ADDT .
it get time for u start using stored procedures and custom forms of ADDT.
wherein u can call a function/ procedure stored in database which does all the house keeping into various tables.. for u in one go.
there are many things which i cannot explain u in one post.
believe u should read a little more about best practices of database design
hope this helps.
mohnkhan