FM as a front end to modify

[Jen B]

In an attempt to have my Data warehouse Department use FM, (hooray), I am trying to find out if there is a way to use FM as a front end to modify the contents of a single SQL 2000 table. My proposed work flow is to populate a FM database from the SQL table by importing the data, make additions and modifications to the table data and then reinsert the data directly back into SQL table. I am unsure how to export the data back into the SQL table directly. Can anyone give me some guidance as to how this can be accomplished?

[mr_vodka]

You can use the Execute SQL command to update it using the UPDATE statement.

another option would be to upgrade to FM9 where you can have your SQL table directly integrate with FileMaker. However, they have warned against tryingto use FM as a true front end to the External Sources; It is good as a compliment to FM for integration.