How to Add records from table to other table

Question

Dear QuickBase Expert,&nbsp;Greetings from Beginners.&nbsp;I have a problem that I need to solve and hopefully will get an insight by asking the experts here.&nbsp;I have two tables on my QB1. Purchase Request Order ( PuRF)&nbsp;2. Purchase Order&nbsp; ( PO )&nbsp;1. Purchase Request Order (PuRF)&nbsp;&nbsp; &nbsp;Contains :&nbsp;&nbsp; &nbsp;PuRF No&nbsp; &nbsp; &nbsp; &nbsp; Products&nbsp; &nbsp; &nbsp; Descriptions&nbsp; &nbsp; &nbsp;Qty&nbsp; &nbsp; &nbsp; Price/Unit&nbsp; &nbsp; &nbsp;Total Amount&nbsp; &nbsp;Manager Approval&nbsp; &nbsp;Once PuRF is approved it should should be saved as a record and we continue to PO steps ( separate table )&nbsp;2. Purchase Order (PO)&nbsp;&nbsp; &nbsp; Contains :&nbsp;&nbsp; &nbsp; &nbsp;Request by&nbsp; : Requester&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PuRF No&nbsp; Products&nbsp; &nbsp; &nbsp; Descriptions&nbsp; &nbsp; &nbsp;Qty&nbsp; &nbsp; &nbsp; Price/Unit&nbsp; &nbsp; &nbsp;Total Amount&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PuRF No&nbsp; Products&nbsp; &nbsp; &nbsp; Descriptions&nbsp; &nbsp; &nbsp;Qty&nbsp; &nbsp; &nbsp; Price/Unit&nbsp; &nbsp; &nbsp;Total AmountIn this case, I would like to simply adding the records from PuRF ( yellow highlight ) to be added into PO without to create another records in PO table. I have tried to do relationship but unfortunately is not success. How can I execute this issue to add PuRF records to PO table ?&nbsp;I do hope my explanation is clear and easy to understand, and looking forward to hearing from the expert here.&nbsp;Regards,&nbsp;Devan
------------------------------Quickbase Admin------------------------------

evanmartinez · Answer

Hi Devan,For your workflow are you looking for a way to copy over records from one table to the other without having to manually reenter the information. So for example when you are done with a PuRF you would hit a button or check a checkbox and the record would be moved over automatically? Something like that is possible with a Pipeline that is set to copy records over. Or if this is something you would want to do once a day you can also use a function like a table to table import to bring records over once a day (for example if your PuRFs move over at the end of the business day. That would copy the records over into the PO table. Alternatively if you just want them to be related and pull down relevant information you can relate them and make sure you have lookup fields created for any field you want to pull down from PuRFs to PO.------------------------------Evan Martinez------------------------------

quickbaseadmi15 · Answer

Hi Evan,&nbsp;Thank you for replying this to me,&nbsp;"For your workflow are you looking for a way to copy over records from one table to the other without having to manually reenter the information. So for example when you are done with a PuRF you would hit a button or check a checkbox and the record would be moved over automatically? "&nbsp;Yes this is exactly what I need to create on my QB.&nbsp;So the workflow is when Users done with PuRF with the request list approved, then they will create PO for final purchasing. I would like to build an Items List that I simply add from PuRF record into PO. This way the users doesnt have to type again in PO list.&nbsp;Is best practice to use Pipeline or Relationship table ?&nbsp;Many Thanks&nbsp;------------------------------Quickbase Admin------------------------------

Forum Discussion

How to Add records from table to other table