I have just created my FIRST Filemaker Pro Layout that I want to connect to an MSSQL database...
Here's what I have done so far..
Set up ODBC and that is working I can see the data if I IMPORT it in to Filemaker Pro/
I've got 2 tables. One is the FileMaker Source the other is the MSSQL source.
Filemaker Source has 28 fields, 0 records.
SQL has 46 fields, 38940 records.
I've set up relationships from the FMP to SQL.
But for some reason I can not see any data or Records in the File Maker Pro Form or Table views.
I only see data when I do a File> Import>ODBC. But I think this is importing it direct to the FMP database. Is that right?
So how do I get the records from the SQL to show up in the FMP??
I guess basically I want to be able to EDIT some data using FMP as a front end, but have this pushed back to SQL so changes are in SQL.
Please Help a n00b figure out what he is doing wrong..