I am a newbie.
I am running a FileMaker Server that is hosting my solution and am integrating (ODBC) with PACS Server. I have already configured DSN and added two PACS tables using relationship graph. I have added a relationship between to the two external tables and a relationship between filemaker table and external table.
On my related table layout (in filemaker) i have created two buttons: import & view. Import button will get data from fm table field (text) and import related data from external table field into another fm table field (container). View button will get imported data in fm table field (container) and open with web browser.
set variable [$$filmno]
set field [Table::FieldName; $$filmno]
execute sql - select fieldname2 from table where fieldname1 = $$filmno
import records [dsn: dsnname; calculated sql text: exttablename::field; add; Windows ANSI]
set variable [$$film]
set field [Table::Field; $$film]
open url ["urladdress"]
I am confused with the above scripting and need help.