I'm working with FileMaker 11, but I've also investigated FileMaker 15 and it's also not possible to specify a target field from a calculation.And "go to field" also cannot be specified dynamically.
But there's still error 102 for "set next serial value". I was hoping that having this script step placed before "set next serial value" would allow me to leave "specify target field" blank. I don't understand why it's optional but returns an error if it is not used. Why is there a checkbox for "specify target field"? I see that I receive error 102 (missing field) when I do not specify a target field. Is there a way to dynamically specify the target field? I only see an option for selecting the table and field from a list of existing fields. I am unable to specify the target field by using a variable.
Now, I've computed my intended next serial value and would like to assign this to a field whose name I have saved in a variable. For each, it will determine the primary key and then find the maximum value in any record for that primary key field. I'm writing a script that's intended to work for multiple layouts and table occurrences.
0 kommentar(er)
