text processing function

[jd9027]

Trying to write this function using filemaker pro 7. I am relatively new to filemaker with some programming background. Planning to use it to create a multiple choice question bank for my students.

The sample picture in the attachment showing the intended logic of the database uses simple items like fruits within the table.

[CoZiMan]

This is more probably a 'calculated field' question than a 'custom function' question.

Create a calculated field to store the selection, calculate always, and use the text concatenation options in the define field to create the relevant data.

Example:

Left(FRUITS::field;3) & "_" & Left(TYPE::field;3) & "_" & Left(SUBTYPE::field;3) & "_" & userid

The 'Left' text functions are to shorten the entries to 3 chars. Not neccessary if you want the complete field added.

That help?

[jd9027]

Thanx CoZiMan, That really helped.