Sorry for this elementery first post. Can anyone help me by first letting me know if there 1. is a way to create relationships between 2 files? 2. how can I do this?
1. A file (database) can have many tables.
2. The relationship graph can show:
a. Tables (& table alias' -all called table occurrences) from the SAME database (file)
b. Tables (TOs) from other FM files/databases it can see thru a network. These are sources.
c. ODBC sources for approved SQL dbs. This is also called ESS (external SQL sources) with proper DNS (data named source) using the correct ODBC drivers. User permissions apply, of course!
3. You can SEE any table as on the relationship graph. You can interact with the data as if it resided in the same file as the graph (layouts, value lists, scripts, etcetera.) You can only DEFINE (modify) the fields at the source db.
Some developers use a "separation model" where the data is in separate dbs/tables from the interface file. As long as a connection allows a table source to be added to the graph, it seems almost as if it's the same file! Note the caveats above.
-- sent from my iPhone4 --
files: A, B
to create a REL from A to B, the B file needs to be added as an 'external data source'
This can be done from file > Manage > External data sources
the path to the file is defined here
Once the file reference to B is added in A, that file (B) and the table(s) defined in it, are available to add as table occurances in the relationship graph (RG) of A
An EDS can also be created from the RG ... add TOC, specify table, Data Source > add filemaker data source
Once the (EDS) link between files is created, relationships can be then created between tables (TOC) in those files
Thank you Beverly. Got me started off in the right direction.
Good stuff Cortical. Thank you much.
Retrieving data ...