Hi all,
I currently have a table of data containing customer orders; dates, names, stock quantities, customer order quantities, an IFELSE statement that shows whether an order is complete or not, etc.
I have a Power Query set up that pulls the data from this table, and IF all of the orders for any given customer are in stock, then the query will take these and create a new table with just those rows.
I want to be able to work from either the original data table or the new one create via my query, and have the other table be updated too.
However at the moment, I am working from within this new table and when I complete a customer order, I delete the row(s) completely, but the original table does not change.
If I change the data/delete a row from my original table, the new query table is update via refresh; but if I delete a row from the new table, I want it to be removed from the original.
The connection is currently only one-way and I want it to go both ways.
Is this possible to set up?
(I have not included any examples at this time as the populated data is confidential. However, if that would be beneficial to anyone trying to help me, then please let me know what you need and I will create a dummy table with example data.)
I currently have a table of data containing customer orders; dates, names, stock quantities, customer order quantities, an IFELSE statement that shows whether an order is complete or not, etc.
I have a Power Query set up that pulls the data from this table, and IF all of the orders for any given customer are in stock, then the query will take these and create a new table with just those rows.
I want to be able to work from either the original data table or the new one create via my query, and have the other table be updated too.
However at the moment, I am working from within this new table and when I complete a customer order, I delete the row(s) completely, but the original table does not change.
If I change the data/delete a row from my original table, the new query table is update via refresh; but if I delete a row from the new table, I want it to be removed from the original.
The connection is currently only one-way and I want it to go both ways.
Is this possible to set up?
(I have not included any examples at this time as the populated data is confidential. However, if that would be beneficial to anyone trying to help me, then please let me know what you need and I will create a dummy table with example data.)
