Table does not edit the correct item

I have a relation manager, who manages the pivot:

Schema::create('country_license', function (Blueprint $table) {
            $table->unsignedSmallInteger('license_id');
            $table->foreign('license_id')->references('id')->on('licenses')->onUpdate('cascade');
            $table->unsignedTinyInteger('country_id');
            $table->foreign('country_id')->references('id')->on('countries')->onUpdate('cascade');
            $table->string('region')->default('All');
            $table->primary(['license_id', 'country_id', 'region']);
 });

In the table:

public function table(Table $table): Table
    {
        return $table
            ->recordTitleAttribute('name')
            ->columns([
                Tables\Columns\TextColumn::make('name'),
                Tables\Columns\TextColumn::make('region'),
            ])

And the form:

public function form(Form $form): Form
    {
        return $form
            ->schema([
                Forms\Components\Select::make('recordId')
                    ->label('Country')
                    ->options([list of countries])
                    ->searchable()
                    ->required(),
                Forms\Components\TextInput::make('region')
                    ->placeholder('Example: Ontario')
                    ->required()
                    ->default('All'),
            ]);
    }

The problem is that when there are two countries, with different regions, and I click to edit one of them, it always edits the first one. It is not choosing the row to edit. How can I do it?

Solution:

add $table->id() in the pivot table

Jump to solution

2 Replies

Solution

LeandroFerreira•4mo ago

add $table->id() in the pivot table

ffffer.•4mo ago

I tried, by it didn't work. Anyway, I'll do it with a json field, keeping it simple. Thanks

Gaming

Programming

Table does not edit the correct item