No Number Popups
You may have seen this problem before. You want to provide a popup list and you also want to normalize your data. You make the jump to using a join file and numerical ID key values. Then you run across the big disappointment where your value list displays as
3 Cat
1 Dog
2 Lizard
Users don't make choices based on the numbers, but FileMaker insists on using them with normalized data. You just want to show Cat, Dog and Lizard without the numbers in the value list. Well, fix what FileMaker should have done properly in the first place. With this powerful FileMaker 7 technique you'll quickly know how!