Can't get related data to show
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.