I am fairly new to Filemaker (I have ver. 16) and I am putting together a script. The application has multiple tables, but I want to use the one script for what I want to do. I am creating a log file that captures the user information and the activity of that user. My problem is that I want to assemble the field name of the primary key and put it into a variable. Then use the contents of the variable to get the data in the primary key.
This is what I mean:
1. Table name: prospect
2. Primary Key: prospect_ID_primary_key
3. $foreignkey = Get (TableLayoutName) & "::" & Get (TableLayoutName) & "_ID_primary_key"
4. Set Field [master_log::mater_log_foreign_id;$foreignkey]
Apparently, the Set Field function sees the contents of $foreignkey as text rather than the actual field name. Is there a way to do this?