April 16, 200718 yr 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?
April 16, 200718 yr 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/
Create an account or sign in to comment