Hi

When you talk about the parent system, you mean a system outside of Ninox, and that this has it's own set of IDs.

Does the Import table just hold the latest import, or does it retain previous imports?

Regards

John

Maybe this could work.

On a button I did a simple update of the current record number field updating the number field of a non-related table. Here is the script updated with your info.

let curRec := this;
let xUpdate := first(select Item where 'Item ID' = curRec.'Item ID');<--Ninox assumes that it could return multiple records that match so just grab the first one since you know there will only be one. Unless you can get many records in Item that has the same ID then you need to add more qualifiers.
xUpdate.('Available Quantity' := curRec.'Available Quantity')

From there you can keep adding fields to be updated.

Hi

If your Item Code is called Ref, and quanitiy called Qty in both your Products and Import tables and you have a flag called Flag that notes new imports vs previous imports then this code will loop through the import, update the products, set a relation between them so you call look back at all imports on a product, and set the flag. If the import has a product that it can't find than it will create one. So your code may be more simple than this if this is more than you need.

for a in select Import where Flag = 0 do
   let b := a.Ref;
   let c := a.Qty;
   let d := first(select Products where Ref = b);
   if d = null then
      let e := (create Products);
      e.(Ref := b);
      e.(Qty := c);
      a.(ProductID := e)
   else
      d.(Qty := c);
      a.(ProductID := d)
   end;
a.(Flag := 1)
end

Set your import table up so that the default value for Flag is 0

Regards John