Database Reference
In-Depth Information
Figure 21-8. When you select ODBC as the type for your new data source, the Edit Data Source
window takes on a whole new look. Instead of just the path to a FileMaker database, you tell
FileMaker which ODBC data source to connect to, the user name and password to use, and which
SQL objects you want to see. Don't worry if these terms don't make sense yet. You'll learn about
them later in this chapter, and many of them don't matter much anyway.
Adding SQL Tables to a FileMaker Database
Your database now has a pipeline to the tables in a SQL data source. But you haven't told it
what to do with those tables yet. Your next stop is the Relationships tab of the Manage Data-
base window, where you can fold the SQL database tables into your overall system.
Choose File→Manage→Database, and switch to the Relationships tab. Then click the Add
Table button, just as though you were adding a normal FileMaker table occurrence. But this
time, when the Specify Table window pops up ( Figure 21-9 ), click the Data Source pop-up
menu and then choose the name of your SQL data source.
Search WWH ::




Custom Search