Pivot not saving to db?
Thoughts on what might cause a select pivot not to save to the db? But manually entering to the DB loads it perfectly.
Forms\Components\Select::make('owningCompanies')
->label('Owning Company')
->relationship('owningCompanies', 'name')
->options(fn() => Company::select('name', 'id')->where('type', 'OWNING')->get()->pluck('name', 'id'))
->preload()
->multiple()
->maxItems(1)
->columnSpan(3), Forms\Components\Select::make('owningCompanies')
->label('Owning Company')
->relationship('owningCompanies', 'name')
->options(fn() => Company::select('name', 'id')->where('type', 'OWNING')->get()->pluck('name', 'id'))
->preload()
->multiple()
->maxItems(1)
->columnSpan(3), public function owningCompanies(): \Illuminate\Database\Eloquent\Relations\belongsToMany
{
return $this->belongsToMany(Company::class)->where('type', 'OWNING');
}
public function owningCompanies(): \Illuminate\Database\Eloquent\Relations\belongsToMany
{
return $this->belongsToMany(Company::class)->where('type', 'OWNING');
}