I am testing the app in offline mode. I have 3 tables:
- product_id |key
- product_id |ref table, [Is a part of?] = on
- product_size_id | key
- order_id |key
- product_size_id | ref table
All tables are related. So when I creat a new product and its related sizes, they appears available to select them in the “Order_detail” view using the [product_size_id].
Here is what happens…
When I go to “Product” => “Product_sizes” and delete a specific Size, instantaniously desappears and is not available to be selected in the “Order_detail”, even if the deletion/change is pending to sync because we are using the app Offline. All good, working as it should be.
BUT only and only if I delete the parent (Product), the childs (Product_sizes) are still available to be selected in the “Order_detail” and this is because the deletion is pending to be sync, once it get synced the deleted parent and all its childs desappear to be selected.
The ‘issue’ is while working offline. Not sure if there is a way, workaround or a nice idea to avoid this scenario? As always thanks for the great help, guys!