Hello,
Is it possible for me to transfer quantity data on one record to another record? As an example, Record A has 10 laptops. Record B has 5 laptops. I would like to transfer 2 laptops from Record A to Record B. I've tried different methods, but I keep hitting a wall.
Qrew LegendCan you tell us a little more about the structure of your data. Are these numbers just a single field on record A and record B. Or are these records in fact, parents and underneath the parents are respectively 10 and 5 child records with the individual laptop serial numbers?
Sure! Using my laptop example, the second option is correct. Each parent record is linked to a child record, and I want to transfer one or more child records from one parent to another. I've also created a product tracker table and a change log table, which allow me to view and track changes made to the parent records.
Couldn't you just update the related parent field on the child record to the new parent? Or what are the challenges you have?
