0

Coping a table into another table...

Hi,

I'm trying to copy a table that has multiple fields into another table (Estimate (Parts) -> Work Order (Parts) -> Invoice (Parts)) so I don`t have to work 3 times. All common fields should be copied (Item link, Qty, Price). Do you have an idea how I could read out each line 1 by 1? I have to use the FIRST to specify the first item but after that I cannot move to the next item. Since I`m choosing (linking the parts to the Estimate/Work order/Invoice) and they are having random ID number I cannot create a formula to copy the next row and it just copies the same first row all the time.

3 replies

null
    • Support
    • 6 yrs ago
    • Reported - view

    Hi, if you simply want to copy the same data records into another table as write, just use the Export function and then import the exported file into the other table via the "import data" button.

    Best regards, Jörg

    • David_Gyenes
    • 6 yrs ago
    • Reported - view

    No, it’s not a simply copy, that wouldn’t work and that’s a long process to export and import every single time manually. I need a code that I can program under a button to trigger the copy. I can do it if I create an ID and than I do an incremental copy based on the ID but if I delete something from the line the ID is not continuous and wouldn’t work. I would need to link together with the line number (or record(Id) if there was such a thing) or tell the program to move to next line.

    • Support
    • 6 yrs ago
    • Reported - view

    Hi, to understand your enquiry better, could you please explain your issue a little bit more detailed? The best would be with an example and as little demo database. Please send it directly to support@ninoxdb.de That would help us a lot in supporting you.

    Thank you for your cooperation. Best regards, Jörg

Login to reply

Content aside

  • 6 yrs agoLast active
  • 3Replies
  • 1820Views