I am pretty new to FileMaker and have developed a database for my company. and have 2 different tables one for costing imports items (which had a direct relationship to import items table and has a portal in costing imports) and another receiving book. I am trying to create a script that will create an entry in the receiving book with item number once I press the script button in costing imports. That will copy item number (from the current import items table) and paste in the product number (of receiving book table).
and my receiving book looks like this.
and the script is like this
Hoping my English is understandable. Thanking you.