AnsweredAssumed Answered

Import value list, delete, recreate as custom value does not work

Question asked by dzittin on Sep 3, 2011
Latest reply on May 5, 2012 by Mingrl88

Summary

Import value list, delete, recreate as custom value does not work

Product

FileMaker Pro

Version

11

Operating system version

XP 2003, SP3

Description of the issue

I imported a value list. It worked. I realized that I really wanted the list local to create a simple runtime. I delete the list. I recreated the list with the same name as a custom list. The list never appeared on field entry. I got a "missing value list" message. I renamed the list thinking this would help - nothing - same message. I checked the field options (this is in a table). All is ok, value list is checked, field type is text as it was before. Nothing.
In desperation, I restored the file. I did not delete the value list reference to another file, but I unchecked it and created a custom list - it worked!

Steps to reproduce the problem

Acquire value list from another file.
Make sure it works on the field to which it is associated.
Delete the list.
Create a new list and assign it to the same field.
The VL name seems irrelevant.

Expected result

Deleting a list from another file and then recreating a local custom list should work and I should not get a missing list message.

Actual result

Missing list

Exact text of any error message(s) that appear

Workaround

None except restore old file. Do not delete old value list. Check custom instead and enter list in custom box.

Outcomes