Multiple Select with pivot table not showing the record because it is soft deleted.
To help others find answers, you can mark your question as solved via
Right click solution message -> Apps -> ✅ Mark Solution