Relating a GUI and a Database

[gsprague]

Hello All,

I built a database in Filemaker Developer and now I want to build my GUI as a seperate file. So far I have only referenced my database file with my GUI file. Do I have to recreate all of my tables in my GUI file that are in my database file? Not really sure if there is an easier way? I will also be making my join tables and global tables in my GUI file.

Thank you!

[gsprague]

OK i figured out that I need to go into the define:relationships to add the table in from my database. When I add a table it shows in my relationships tab:graph, but not in my tables tab. Are my tables not suppose to show up in there?

[Ender]

The key to separating the GUI, or Interface file, is using File References. In your Interface file you should set up a file reference to each data file, then on the Table Occurance Graph, add a table occurance for each data table (using the file references.)

Another method, which may be easier if you haven't done too much work on your Interface file yet, is to build the Interface within the data file, and then separate it when you're done.

See my post in this thread for details:

http://www.fmforums.com/threads/showflat.php?Cat=0&Board=solutions&Number=123265

[bruceR]

The tables under the Tables tab are only tables in the same file. Sounds like you have already added the table occuurence from the external file to the graph. That should be all you need to do (except add or modify other table occurrences as necessary for your struture)