Creating Dynamic Newsletter Question

[monoone]

Hello;

I am creating a dynamic Newsletter. I am unsure about the DB structure. What I have is two tables one called Newsletter the other Stories - I want to enter multiple Stories into One Newsletter so it would be One Newsletter to Many Stories. I guess the question is - How do I input several stories into one newsletter? Many StoriesID to One NewsletterID?

I am sure this is a dumb question but if anyone can answer this It would really help.

Thanks,

Eric

 

[ecobb]

Yep, in your Stories table, just have a column called NewsletterID and have the value reference back to the ID of the Newsletter each story should be associated with.

Hope This Helps!

Ecobb

"Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer." - Homer Simpson

 

[monoone]

Would I use a CF Loop? "See Question Multiple inserts with CFLOOP"

-Eric