AnsweredAssumed Answered

Can't get related data to show

Question asked by RemyFarrell on Nov 20, 2011
Latest reply on Nov 21, 2011 by philmodjunk

Summary

Can't get related data to show

Product

FileMaker Pro

Version

11

Operating system version

OSX

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?

Outcomes