Could not find where the miss during Create/Edit Form single Select, get two values and stored into two different columns

[suhaimi-masri-ent]

Package

Form builder

Package Version

v3.3.0

How can we help you?

Error screen

Trying to do screen

the code for $form->Schema in TafakutResource.php

` Select::make('azam_id')->required()->label('Azam ID')
->relationship(name: 'azam', titleAttribute: 'id')->inlineLabel()
->getSearchResultsUsing(fn (string $query) => Azam::where('azam_id', '=', "%{$query}%")
->pluck('azam_id', 'ahbab_id'))

                ->getOptionLabelFromRecordUsing(fn (Azam $record) => "{$record->azam_id} {$record->ahbab->fullname}  ({$record->duration} H)")
                ->optionsLimit(20)
                ->preload()->searchable(), 

protected function mutateFormDataBeforeCreate(array $data): array
{
    $azam_id = $data['azam_id'];
    $data['azam_id'] = $azam_id;
    $data['ahbab_id'] = Azam::find($azam_id)->ahbab_id;
    unset($data['azam_id']);
    return $data;
}

protected function mutateFormDataBeforeSave(array $data): array
{
    $azam_id = $data['azam_id'];
    $data['azam_id'] = $azam_id;
    $data['ahbab_id'] = Azam::find($azam_id)->ahbab_id;
    unset($data['azam_id']);
    return $data;
}

`
the migration table

Schema::create('tafakuts', function (Blueprint $table) { $table->id(); $table->timestamps(); $table->foreignId('azam_id')->constrained()->cascadeOnDelete(); $table->foreignId('ahbab_id')->constrained()->cascadeOnDelete();

[suhaimi-masri-ent]

OK Done! Horayyy!!!

[suhaimi-masri-ent]

Try to add this statement:
->relationship( name: 'azam', titleAttribute: 'id', modifyQueryUsing: fn (EloquentBuilder $query, Get $get) => $query ->where('flag', false) )
to filter the query with flag=true, but seems it was not working.

[suhaimi-masri-ent]

Try to add this statement: ->relationship( name: 'azam', titleAttribute: 'id', modifyQueryUsing: fn (EloquentBuilder $query, Get $get) => $query ->where('flag', false) ) to filter the query with flag=true, but seems it was not working.

Weirdo. Now simply solve by doing this

[suhaimi-masri-ent]

And, its only reflect on Creation form, for Edit form it became like this

[suhaimi-masri-ent]

slightly change the where('flag', false) to orWhere('flag', false)