adding content to existing field

[AndreasBoehmer]

Hi,

I am trying to create a web-forum on a Filemaker database.

What I thought I would do is create one field that holds all the responses

to each topic. I call this field "response". When a user submits his

response-form, I want to add, whatever he wrote, to the pre-existing content

of the "response"-field.

Eg:

1. Response-field holds following content: "This is response one".

2. User submits a form from the website containing "This is response two."

3. The "response"-field in the FM database should now look like this: "This

is response one. This is response two."

Can anybody give me an idea of how to accomplish this?

[CaelC]

You can use the main response display field as a calculated field that concatenates the submissions from the other fields ... but this isn't a very good solution. Better to use a related file that holds all the responses.

I hope this helps,

Cael.

[AndreasBoehmer]

Thanks, CaelC. That's what I will do.

[pourtoes]

Hi, I'm trying to do a very similar task. did writing out to a file work? mind elaborating on how you went about this/

THanks

[Garry Claridge]

If you want to keep updating an external text file you could use the Troi Plugin. http://www.troi.com/software/fileplugin.html

However, using a related table with each response to a thread of discussion would be the most effective database solution.

All the best.

Garry