How to massively link all invoices to their customer?
Ninox Profile

I have imported a customer table with 300 records and an invoice table with 500 records. Both tables have the customer no. How to massively link all invoices to their customer? I know how to do it one by one from the tutorial. Is there a way to complete the linkage all in one go? Please advise. 

Ninox Profile

See here:
https://ninoxdb.de/en/manual/tables/mass-data-updates

Birger

Ninox Profile

Thank you, Birger, for the information.  I tired the mass-data-update as you suggested.

It's very useful for the regular data fields. However, the linked filed seems to take the data as row-id and ended up linked to the wrong customer.  

For example, in my invoice table, I have imported cust no, 22NDTI, I added a linked field to the customer table(cust no).  I used the mass data update, only the number 22 was updated to the linked field. The customer with row_id 22 was linked to the customer no "22NDTI" in the invoice.  As row_id and cust_no are different fields. I got a mismatch. 

Any further solution is greatly appreciated!  

Serina

 

 

Reply