How to massively link all invoices to their customer?
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.
2 replies
-
See here:
https://ninoxdb.de/en/manual/tables/mass-data-updatesBirger
-
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
Content aside
- 6 yrs agoLast active
- 2Replies
- 2247Views