Hi all,
I am struggling with a concept and hoping for some guidance.
I have a Customers table with a CustomersId Key column and I have an Orders table that includes the CustomersId and I want the user to be able to select a โMerge this Customer withโ and select a โInto this Customerโ and have the app update the CustomersId in the Orders table for the rows with โMerge this Customerโ with the CustomersId from the โInto this Customerโ.
Additionally would like the Customer in the Customers table to be deleted.
I imagine the app user to be able to do this through a form.
The sequence being:-
Select a customer from โMerge this customerโ via a dropdown list.
Select a โInto this Customerโ via drop down list.
Then a Save or something to set it into motion.
Appreciate any advice.
Many thanks
Simon
I understand you have a customers table and then an orders sub-table. Just so Iโm clear are you:
1 = Trying to merge 2 customer records
2 = Moving order records from one customer to another
3 = Both of the above
Or am I totally wrong altogether
Hi Simon
Option 3 thanks.
Although in order of preference
3.
2.
1 by itself is not an option.
I use google sheets.
Thanks
Iโm just wondering if someone might have some idea on how I might go about this task.
I apologise if it is in the wrong section.
Thank you
Simon
Me too!
User | Count |
---|---|
37 | |
26 | |
21 | |
17 | |
15 |