I can't find anyone else with this specific problem, I have a Parent table "Jobs" and a child table "Routes". The routes table is cleared daily so a web scraper can dump new ones into it. The problem I have is when the child table is cleared the parent table looses the values it pulled from it through a Ref. I do not have "Is part of" enabled so I thought this should not be happening. Please help if you know a solution.
I figured it out. A bot was assigning the main Ref value from the child table and the other dependent values from that child table were assigned based on the data table's [Ref Value].[Column]. I noticed only the value the bot was assigning directly was sticking around after the child table got cleared so I changed the bot to go ahead and assign all the values that come from that child table instead of relying on the table reference and viola they stay now.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |