Newbies KieranYeates Posted July 27, 2006 Newbies Share Posted July 27, 2006 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 More sharing options...
Vaughan Posted July 27, 2006 Share Posted July 27, 2006 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 More sharing options...
wintergreen Posted August 14, 2006 Share Posted August 14, 2006 I've been using the list function for quite a lot of things. Seems as fast as most other functions. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now