filemaker pro script examples to clear field in all records

They normally have only a “1” or an ID number in them, but they give FileMaker much of its power and flexibility.

This month I’m going to write about a few little fields. This is better if you’re choosing IDs for new records, as you’ll often want an ID# which doesn’t yet exist in the local file. The second method will show all the ID#s in the other file.

This is good if you’re using it in Finds, etc. The difference between these methods is that the first way will show you only ID#s which you’ve entered in your local file. You’d use this when you have an ID field and you want to show names to identify the ID numbers.Īnother way to do this, without having to create the field, is to just use the ID field in the other file for the Value List, choosing the file with “Specify File,” choosing the ID field, and also showing the Name field. I’d talked about creating a calculation field in the local file to mirror a field in a related file that you wanted to use as part of a Value List, as the second field, using the “Also display values from” checkbox. I left out an obvious point about using related fields for value lists. Before getting started I wanted to fill in an omission from last month’s column.

Filemaker pro script examples to clear field in all records