If I understand correctly, you have a SQL script which produces the results
of the formula (or whatever it is called) you provided. Not knowing
Oracle/SQL in the least, I will just assume that you can send the results of
that formula to a text file.
You tell script FileMaker to import that file's record(s), using an
intermediate file which would, in turn, provide the source for updating the
records in the master file. You would need something common which would tell
FMP what record the SQL output belongs to, so a relationship could be
established.
You could then either do a lookup to permanently populate the master file
with the updated info, or just display the related information.
Matt
> I builded a script with the following:
>
> select count (*) from v_employee
> where home = '345'
>
> how do I update a record with the result of my SQL? Appreciatte any help.