I have a blog table...
that has another associated table...
BlogID (primary key)
but now I want to be able to attach a poll to blog if needed...
RatingID (primary key)
RatersIP (varchar 15)
BlogID (foreign key)
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.
PollID (primary key)
PollQuestion (varchar 3000)
PollIpAddress (char 15)
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.