How to copy some records from Table1 to Table 2..

Ninox Profile

Hi Everyone,
My purchase orders have arrived to my warehouse. At this stage, I will make a waybill entry. However, since there are too many order items, it is very difficult to enter the waybill one by one. How do I handle this shorter. Or how do I transfer the fields of the current table to another effortlessly?

Best regards.

Ninox Profile

You could filter by column by clicking any column header in the list, or you could add a column specifically for this purpose.

Ninox Profile

For a description of how to copy or move records from Table1 to Table2 see:

 

https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/trigger-use-data-in-table-1-to-create-line-in-table-2-5f561c208dfe7919e5b3920f?post=5f58e25b539bd77f590cad2c&page=1

Ninox Profile

Hello Dean,

Thank you very much for your answer.

By the way, I also came up with a solution and it works fine.

Let me talk briefly;

I linked the waybill items table to the order items table. When I click this linked field, the Order Items table opens in full. I created a new criteria cell here, displaying only the relevant order items. After that, all I have to do is click on them and thus the order items are copied to the dispatch items table.

Reply