Okay, I think this may be a foolish question, but I've searched the forms for a little while and can't seem to find an answer to my question. How does one execute a SQL statement on tables in a FM database? I've looked at the script 'Execute SQL' and it seems to be only designed to execute SQL on other databases. Is there some easy way to execute sql and, say, fill in a field value in another table with the result?

Thanks for any help,

Nazarre

The only way to really do it is to set up FM as an ODBC data source (with Filemaker Server Advanced) Then you can use any ODBC client (even Filemaker Pro) to insert data.

Dana