Linked table? Filemaker with SQL?

[erapp]

I am a developer and familiar with db's, but new to Filemaker. In Access it is possible to create a "linked table" which links Access to a table in SQL Server. Is this possible in FileMaker 8? Basically, I need to link the data in a table in FM to an identical table that exists (and must exist) in SQL Server (2005). I was going to use a script to execute a query on the sql db but the client would prefer to use a "linked table" if it is possible.

Any help would be greatly appreciated.

Thanks!!

[mr_vodka]

If you are talking about connecting FROM SQL Server TO data in FileMaker, then you will probably will want to read this:

http://www.filemaker.com/downloads/documentation/fm8_odbc_jdbc_developer.pdf

If you are talking about connection TO SQL Server FROM FileMaker then you will need FM9.

[erapp]

If you are talking about connecting FROM SQL Server TO data in FileMaker, then you will probably will want to read this:

http://www.filemaker.com/downloads/documentation/fm8_odbc_jdbc_developer.pdf

If you are talking about connection TO SQL Server FROM FileMaker then you will need FM9.

mr v,

Unfortunately (based on your answer), the primary data entry will occur in FileMaker. So, I was hoping to link to (and therefore update) the table in sql server (i.e. the user creates a new record in the "Widget" table in FM 8 which then propagates to sql db table). Is there a specific feature in FM 9 that I can refer my client to? Or is just enhanced odbc functionality?

Many many thanks!!

[mr_vodka]

Well with FileMaker 9, you can have " live connections" to some External Sources.

If you dont need it live, you could always just use a Execute SQL command to perform whatever fuction that you need.

[erapp]

Many thanks for your help!