I am new to FileMaker and I am considering using it to develop and replace legacy 4GL systems built for a number of clients over the last twenty years. The product seems ideal in many respects for fast prototyping and development, however I am having some trouble with the fact that scripts and functions appear to have different techniques for addressing programmatic issues.
I want a global variable to represent the content of a specific table record and I would wish it to be general to all tables. It would be preferable to set it up as a function.
Table with Field1 and Field2
Procedurally I would expect to
In a script:
Find required record
Address first field
Set variable to run function
Write to variable:
Get(ActiveFieldName) & “;” & Get(ActiveFieldContents) & <CR>
Goto NextField at end of file exit.
Any tips to address this or similar issues would be appreciated.