grumbachr Posted October 8, 2007 Share Posted October 8, 2007 i'd like to have a calc field in table::A show all the values from a related field in table: it is a one to many relationship when i write a "case" or "if" calc i only get the values from the first related record. what is the trick to getting it to evaluate all the related records? (i asked this before but deleted when i thought i figured it out on my own.) Link to comment Share on other sites More sharing options...
bcooney Posted October 8, 2007 Share Posted October 8, 2007 List() function Link to comment Share on other sites More sharing options...
comment Posted October 8, 2007 Share Posted October 8, 2007 The List() function was introduced in version 8.5. If you have version 8A, as your profile indicates, you can (1) define a value list of related items only, and use ValueListItems() to list them (unique only, sorted), or (2) use a custom function. Link to comment Share on other sites More sharing options...
grumbachr Posted October 9, 2007 Author Share Posted October 9, 2007 Thanks the list function is working but i'm not able to do finds based on this calculated field. any suggestion on how i can do that? Link to comment Share on other sites More sharing options...
bruceR Posted October 9, 2007 Share Posted October 9, 2007 Please explain. You can in fact do finds on a calculated field, though they may be slower. Link to comment Share on other sites More sharing options...
grumbachr Posted October 9, 2007 Author Share Posted October 9, 2007 Using the List function to show data from table:b in table:a things work just fine. (very greatful for the help with this) but if i enter find more on table:a and try to find any value in the calculated field i instantly get a "no records match this find request". Link to comment Share on other sites More sharing options...
comment Posted October 9, 2007 Share Posted October 9, 2007 Make sure the result type of your calculation is set to Text. If that's not it, post an example. Link to comment Share on other sites More sharing options...
grumbachr Posted October 9, 2007 Author Share Posted October 9, 2007 (edited) Now I'm just getting frustrated. I was building an example to share but its working like i want it too. But my original is setup just the same but its not working. Edited October 9, 2007 by Guest Link to comment Share on other sites More sharing options...
grumbachr Posted October 9, 2007 Author Share Posted October 9, 2007 Maybe I've found a bug or a limitation of our server. On a hunch I grabbed my db from the server and opened it locally, without making a single change to the actual file, everything has started working as expected. My example works from the server so its still kind of inconclusive at this point but looks like I need to see if there are any patches to my server. There is also a big difference in records/file size. 7000+ records at 30MB vs 3records at 68KB Sample file included for the fun of it. List_function.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6135 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