The body of a layout represents a single record in that table occurrence. Here are a few things to know that I hope will help:Įvery user interface ("Layout") in FileMaker is based on a table occurrence. It's meant for rapid application development, and as such it has certain paradigms in mind. You can even add tables from ODBC sources to the relationship graph, which is the primary way that you get data from multiple tables in FileMaker.įileMaker is a little hard to wrap your head around coming from an SQL background. However, creating, editing, and deleting records all work as normal. For example, if you delete a field ("column") in FileMaker, it doesn't get deleted in the SQL database. Tables from ODBC sources are "shadow tables". Mostly, ODBC data sources in FileMaker don't get all the FileMaker goodies in Manage Database. There are some limitations to ODBC connections, which will probably be irrelevant in your case. That is, the data will be "live", with no need for over-night copying about. This will let you base layouts on an MS SQL table just as though it was a native FileMaker table. ![]() (See "Using FileMaker Pro, I want to create a live connection to a MS SQL Server, Oracle or MySQL data source.") To expand on user4166144's answer a bit, you can add MS SQL as an external data source to FileMaker using ODBC.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |