1 Reply Latest reply on Nov 21, 2011 11:15 AM by philmodjunk

    Can't get related data to show



      Can't get related data to show


      FileMaker Pro



      Operating system version


      Description of the issue

      I am trying to set up a fairly simple contacts database comprised of firms and employees within those firms. The database comprises of 2 tables: a firms table and an employees table.

      I have created a relationship between the two with the firms tables as the parent table and the employees table as the child table with a one to many relationship from the former to the latter. In the employee layout I have populated the foreign key field with the firm name in a drop down menu which works fine. I am able to select the appropriate firm for the appropriate employee.

      The problem is that when I try to pull data from the parent (firms) table by dragging, for example an address field from the firm table, the field remains blank. In edit layout mode it shows up as ::address.

      I suspect I am missing something pretty obvious.

      Any thoughts?

        • 1. Re: Can't get related data to show

          Did you know that you have posted to the portion of this forum intended for reporting possible bugs? Not a big deal really, but you might have already had several people respond to your question had you posted to the FMP Pro forum, (See tab at top of screen).

          What data type did you specify for the two key fields? If you are using a name (a bad idea BTW), they should both be listed as fields of type "text" when you check them in Manage | Database | Fields.

          The problem with using name fields (for both companies and people) is that names are not unique and they get changed from time to time.

          Imagine what might happen if "acme construction" was bought out and changed it's name to "Pinnacle Services". If you edit the name in your parent field, all the linked records that link to the original Acme construction name now disappear as you've broken the link.

          It's better to use an auto-entered serial number for linking your two tables. This avoids both issues with name changes and also makes sure that he value used to link records is always unique to a specific company.