1 Reply Latest reply on Jan 14, 2010 9:50 AM by philmodjunk

    Linking records



      Linking records




      I am familiar with SmarTeam (Oracle dB) and totally new to FileMaker Pro.  In SmarTeam each object has a profile card with attributes (not sure what the equivalent is called in FileMaker Pro) where I define the object via attributes and it's associated electronic file (e.g. A PDF, Word Doc, Excel Doc, etc.)  In SmarTeam when two or more objects are related (externally) I can create a Document to Document Link within the database.  For instance; I have three objects related to a particular part number (common attribute) such as a Specification, Procedure, or Calculation, and want all three objects in the database to show a 'General Link' to each other. The nice thing about this linkage is you can view the related document(s) when a search for any one is found. 


      Is this possible with FileMaker Pro? Please advise what that mechanism is. How do I display the links?


      Thanks in advance for your reply.


      Should this question be in a different forum?  Which one?



        • 1. Re: Linking records

          I think what you want is the ability to link data in one record to data in another record. In filemaker, you'd use Manage | Database | Relationships to define relational links between one table occurrence and another. A table occurrence is a box on the graph that "points to" a specific data source table. The two table occurrences in a relationship may even point to the same data source table, enabling two records in the same table to be linked.


          If you want to link different documents, you'd store the document (or its file path reference) in a container field and use a second unique ID number field in the same record to establish a link to another document stored in another record's container field.


          This is a very generalized description, and the implementation details multiply and vary rapidly depending on how you want to design your database.


          Note that Oracle is most likely doing exactly the same thing "under the hood". The Smart Team developers used another software program such as Visual Basic to design the screens you see and interact with and which passes the data into tables and relationships defined in Oracle. Duplicating the capabilities of Smart Team in Filemaker would likewise require that a developer spend the time desiging the required tables, relationships and user interface. Unlike Oracle, both the interface and data design can be done in one application: Filemaker.