How to copy a row or just few collummns from one table to another using a button

With this code (button in Inventory List table) you can copy records to another table. 

---
let variable1 := Inventory_Field1;
let variable2 := Inventory_Field2;
let variable3 := Inventory_Field3;
let c := (create 'Delivery List');
c.(Delivery_Field1 := variable1);
c.(Delivery_Field2 := variable2);
c.(Delivery_Field3 := variable3)

---

Examine the code and change the field names to match yours.

This will copy 3 fields, you can add more fields if you like.

Hello Guys,

Why can't one just do:

let c := (create 'Delivery List');
c.(Delivery_Field1 := Inventory_Field1);
c.(Delivery_Field2 := Inventory_Field2);
c.(Delivery_Field3 := Inventory_Field3)

?

It's a matter of context. Inside the parentheses "c.( … )", the context is the just created record of the table "Delivery List", designated by the handle "c". When you put the identifier "Delivery_Field1" inside the parentheses, it designates the field so named of that record, and its OK. If you put the identifier "Inventory_Field1" inside the parentheses, you are trying to designate a field so named of that same record, which does not exist.

You can give the Inventory recor a handle and then use it, such as

let a:= this;

let c := (create 'Delivery List');
c.(Delivery_Field1 := a.Inventory_Field1);
c.(Delivery_Field2 := a.Inventory_Field2);
c.(Delivery_Field3 := a.Inventory_Field3)

you can also use this format

let a:= this;

let c := (create 'Delivery List');
c.(Delivery_Field1 := a.Inventory_Field1;
Delivery_Field2 := a.Inventory_Field2;
Delivery_Field3 := a.Inventory_Field3)

Regards John

Thanks guys!

I think all would benefit with a clear explanation of scope and types returned for certain functions. The manual that serves as reference for NX script leaves a ton to be desired.

In this instance you've clarified my doubts!