Comments - With Time and Name Stamp

[Dave Cowley]

Hi

Ive had a look through the forum and can't find the keyword that I am looking for so I was hoping someone could help.

I have the trial version at the moment and I am trying to add a custom text box under my fields where I can add comments then put a date stamp etc.. by the side.

I just need to know what it is called please so I can research and learn how to use that section to see if it will do what we want before purchasing.

Thanks in advance for your help and sorry if this is the wrong section of the forum.

thanks

Dave

[mr_vodka]

I would advise you to create a separate comments table that would have related records to the main record table. Each new comment added would be it's own record. You could create a date timestamp field with the auto entry turned on for creation that would capture when you create each record. You could use a portal to display the table of related notes.

[Dave Cowley]

Thanks, i have managed to set this up now!

I am however having one problem. When i add a comment then click out of the box it keeps adding the same information that was there before in the previous comment.

is this because i dont have a new comments button or something?

thanks

Dave

[mr_vodka]

are you using the correct related fields? pleas post a screenshot of your relationship graph. and portal in layout mode.

[Dave Cowley]

heres the info

thanks

[mr_vodka]

Well first I would strongly advise you to create a primary ID field in each table. Use a number field with auto-serial option. Also create a number field in your comments table that will act as the foreign key. Your relationship should be based on the primary key ID of your "test" table related to this new foreign key in your comments table. When you create the relationship, there should be an option for allow creation of records. Turn it on for the comment side of the relationship.

[Dave Cowley]

Thanks, i have it sorted.

I appreciate your time :)