Jump to content

Joining text from related records


KieranYeates

This topic is 6437 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi quick question, i searched but couldn't think of the correct words to use to search for my problem

i have a port related to a database, with a list of products in it. on a layout showing a quote form. so my 2 tables are Quote and Products. the portal has a few related products to the quote. i want to take all the product names and put them in 1 feild one under another.

"Product1

Product 2

Product 3 "

and so on.

all i can find is to add numbers together from related records using a calculation feild and the sum function. can i make a loop to get the data out or is there a function that can do this for me?

Link to comment
Share on other sites

The List() function does this, but it's new to FMP 8.5.

Alternatively you create a related value list to concatenate the fields together using the ValueListItems() function, but this will return a list that is sorted alphabetically with duplicate entries removed. It's also a slow function to process. (I dunno whether the List function is better I haven't used it yet.)

Link to comment
Share on other sites

  • 3 weeks later...

This topic is 6437 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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