Comment bank....

[russtic]

Still struggling, thought this was simple but cant work it out..

I have a list of students and I want to do reports which will include a comment.

I have set up the table of students and a table of comments. I have set up a drop down list with the values from the comment table... All okay..

what I want is for a new comment written in the class list to automatically make a new record in the comments table so that it is then available ...

Sorry for another newbie Q.

[jdu98a]

It seems like what you're doing could possibly be accomplished by just using a value list displaying values from a comment field that was on the student table itself.

The only reason I can think that you would need to use a separate table for comments is if you needed to be able to show more than one comment per student. If that is the case, then all you need to do is use a portal displaying records from the comment table. Give the portal the ability to create records and you're in business.