Announcements
No record found.
I am trying to sync the Warehouses table and am getting an error initializing the synce because there is a filed "MainRefillingWarehouseID" that is related to the key "WarehouseID". I have a warehouse ID 10 that is the refilling warehouse for a lot of other warehouse so I need to load the table with warehouse 10 the other records are created.
How can I handle an initialization like this? I'm sure this is a common pattern of "parent-child" relationships that comes up in other areas as well.
The map is below and is inherently mapped correctly once the data is loaded.
I couldn't find another option so I ended up altering the data to load the warehouse record.
1. Remove the transit and refilling warehouse from the warehouse records.
2. Load the warehouse records
3. Reload the refilling and warehouse records.
I don't know if there is a better approach for self-referential tables but this worked to get the dual write working in my test and prod environments.
Nope, that is the approach, Dual Write struggles with referential data and always has. I am not aware of any solution for this at the moment. Your approach is the only real option!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 509 Super User 2026 Season 1
Giorgio Bonacorsi 375
Adis 268 Super User 2026 Season 1
