I have a blog table...
BlogID (primary key)
that has another associated table...
RatingID (primary key)
RatersIP (varchar 15)
BlogID (foreign key)
but now I want to be able to attach a poll to blog if needed...
PollID (primary key)
PollQuestion (varchar 3000)
PollIpAddress (char 15)
Here's my question... I want to be able to add the poll at the same time as the blog. How do I do that? This means that if a certain checkbox is checked then all the poll at the same as the blog... if it is not then the only add the blog.
This is different from a rating because there is already a BlogID to reference. How do I add the blog's BlogID to the myBlogPoll as a foreign key. I am having a hard problem with this is because the BlogID is added to myBlog(Table1) as an identity (set to increment by 1).
Thanks in advance,
PS... I am trying to do the same thing as this forum is doing while taking in threads.