November 2, 200817 yr I have a table with a calculated field whose value depends on various conditions. I use that field for a value list elsewhere. I would like to 'snapshot'or 'save' that value list to fix the contents so that it can be applied later, even though the values in the original table, and hence the original value list, may have changed. Hope that makes sense. Any way to do that?
November 2, 200817 yr A way is to copy all those values and past them into a custom value list. Another is to create a .txt file with those values, open that file with FileMaker so that it creates a new file with only those values as records. The new list will come from values of this new table.
November 2, 200817 yr You could also set a field in some table to the current ValueListItems value, and use that as the base for another value list. It really depends on what you hope to accomplish.
November 3, 200817 yr Just save the value list items to a text field in a single record table. Here is the script to do it: Save Value List Set Field [ SingleRecord::SaveValueList; ValueListItems ( Get ( FileName ); "YourValueList") ]
Create an account or sign in to comment