[thelist] CF Message Board

[Daniel J. Cody]

Hey Chris -

As Raymond mentioned, you may want to check out forumspot.org - good
stuff there.

If you're interested in doing it for the sake of doing it though, thats
cool too :)

Chris Silwedel wrote:

> Basically i'd like the user to be able to enter a new subject name and an
> accompanying message on the one form. I've designed the database to have a
> table for subject and for messages. messages will be linked to subject.

what do you mean by linked?

> problem is, how do i create a new entry in the subject table AND put the new
> subject id into the message table for the link?
 
you should have your table include a column for message id as well. Have
this be your primary key, and have it pull off a sequence(or
auto-increment/identity i think they call it in the MS world) so that
each time you insert a new message and subject in, that message id gets
incremented by 1. if you can't use a sequence, you can doa  query that
will get the message id of the last row in the table and then you can
manually increment that by one and use that as the value for message id.

hopefully that makes sense too :)

Shout back if you have any more questions 

.djc.