FM7 data linked to SQL data?

[Jack Tripper]

Hello all. I have a FM7 file/layout with approx 10 fields on it. I want to add two more fields (that are on my SQL Server from another application)

I already created the DSN in control panel. I would like to just add these two fields on my FM layout. One of the SQL fields is the same as my key field in FM. How can I do this?

[Wim Decorte]

you can't add fields from a non-fm source. You'll need to create those fields in FM and import the data from SQL Server before you can display it in FM.

[Jack Tripper]

Well that sucks! I was going to import this data daily, but that is not good enough for the users. They enter the data in the other system first, then immediately go to FileMaker and do what they need to do.

Can you write connection strings in FileMaker? I dont want to have to setup ODBC connections for every FileMaker client..

[Wim Decorte]

No connection strings, everything you want to use has to exist in the "Data Sources (ODBC)" as a DSN.

What you could do is use scripting on the SQL backend so that it pushes data into filemaker whenever new data is entered. Like an ODBC connection from your SQL server directly to FileMaker Server Advanced. Or using XML...

This way you control the connection entirely from your SQL Server end.

Edited July 8, 2006 by Guest