Data String

[jbullydawg]

Good morning,

I'm working on developing a contract for our High School Independent Study instructors. The manager of this unit wants to be able to see all the courses for a given instructor on one line in the contract.

Ex. Course 1, Course 2, Course 3

The Courses table is, of course, set up so that there's one course per record with a serial number setup as the primary key. An instructor is selected from a drop down list for each course. The number of courses a given instructor teaches varies from one instructor to the next.

I would have no issue doing this in a normal report but to get all of one instructor's courses in a string is not something I'm familiar with.

Any ideas?

[sbg2]

You can create a value list and then use the substitute to replace the carriage returns with a comma. An example file of this can be found in the following thread http://fmforums.com/forum/showpost.php?post/210869/