jschmo

Set Foreign Key - No Portals

Discussion created by jschmo on Oct 3, 2016
Latest reply on Oct 4, 2016 by CICT

I have been given the task of learning how to use Filemaker and I haven't been able to figure out how I can set the foreign key field on a table. The getting started PDF mentioned portals but I don't think the server is using portals because when I try to get related layouts it returns nothing.

 

Here is a snippet of the code I have been trying to get to work.

 

http://pastebin.com/raw/t8qj2NHN

 

When I execute this code I get Error: Field cannot be modified. Is there a specific way to set the id of the foreign key field? Here is also an image of the configuration for the foreign key field.

 

Screen Shot 2016-10-03 at 11.38.23 AM.png

Outcomes