Integrated FM9 with SQL - Updating?

[drjay]

To simplify the issue lets say I have a table in sql called "customers" and it only has custid (serial, primary) and firstname. In FM I have the same two with the relationship being custid.

I can import just the custid and it will fill in firstname with the proper data - so all is well. If I create a new entry in SQL (with a new custid) I can simply type the custid into the field and the correct data will show up. What I'd like to do is when a new custid is created in SQL that it's automatically shown in FM. I hear this is possible but without doing a looping import or a portal I can't see how.

Any ideas?

[Josh Ormond]

If you are talking about FMP 9...you can create an ODBC connection. With which you undate the SQL table directly, no FM table involved, no import.

Look in the Help for making an ODBC connection and adding a shadow table to the Relationship graph.

Post back with questions.

Edited September 22, 2008 by Guest

[drjay]

Boy am I a goon, I set it up backwards. I setup odbc right but instead of redesigning the layout it created (didn't notice it created one), I put the individual fields into a different table and related the two. Not really sure why I did it.

I just changed to the customers layout and hit refresh and it finds all the new ones. Blaaaah. Thank you for humoring me. :P