AnsweredAssumed Answered

Copying a field in one table and paste in another table

Question asked by samtea on Mar 27, 2018
Latest reply on Aug 9, 2018 by beverly

Hello Friends,

 

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).

 

Screen Shot 2018-03-27 at 5.37.49 PM.png

 

and my receiving book looks like this.

 

Screen Shot 2018-03-27 at 5.38.21 PM.png

 

and the script is like this

 

Screen Shot 2018-03-27 at 5.45.21 PM.png

 

Hoping my English is understandable. Thanking you.

Outcomes