Inserting to Tables
I've been reading the relational table threads and understand the Primary and Foreign key relationships, but not the sequence to create the pages
I would like visitors (who are logged in) to create a post in the blogs table.
There are three tables:
Visitors:
VisitorsID PK
VisitorUserName
VisitorsInfo
Blogs:
BlogID PK
BlogVisitorsID FK
BlogSubject
BlogMessage
BlogDate(timestamp)
BlogItems:
BlogItemsID PK
BlogItemsBlgID FK (BlogID PK)
BlogItemsVisitorsID FK (VisitorsID PK)
The insert page to post a blog will have one user with many blogs. The fields are:
Username (from the Visitors Table)
Subject (inserts into the Blogs Table)
Message(inserts into the Blogs Table)
I need to know how to create the insert page above. How do I populate the Username Field from the Visitors table? How do I post all three fields for that session into the Blogs table?
Their post appears as a repeating table:
User Name Subject Posted (date timestamp field)
Fred Christmas Party 12/21/09
Susan Does anyone have a receipe? 11/14/09
If you click on the subject you're taken to the detail page:
Fred posted on 12/21/09
Christmas Party
You can RSVP to attend before 12/15...................