Dynamic Field on Same Layout with Portal
Coming from using Cold Fusion and web application building to Filemaker. I was able to do this with CF and dynamic flash tables in CF and was wondering if this is possible in Filemaker:
I want a portal on a layout page to display a list of records from another table. The user would choose one of those records. The "name" field of the record chosen in the portal would be automatically placed in the "Name" field on that layout. As the user clicks different records in the portal the name field on that record would change dynamically to what is in the name field of the record chosen in the portal from another table. If this can be done, can it be done with multiple fields at once?
I hope you understand.
You can do this with tiggers and global fields or global varibles.
Clicking portal field can load a corresponding global field or variable.
An OnRecordLoad trigger can fire a script that uses set field to copy data from any non-empty globals to their corresponding fields when you shift the focus to the new record.