Jump to content
Sign in to follow this  
jbullydawg

Data String

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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/

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.