View Single Post
  #2 (permalink)  
Old 07-18-2008, 04:11 AM
Mohiuddin_Khan_Inamdar@adobeforums.com
 
Posts: n/a
Diggs:
Default Re: Database design help please..... insertinto two tables...ect....

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
Reply With Quote