Relationship or select2_multiple field not using pivot table

[alancwoo]

I'm sorry if I'm missing something obvious, but am trying to set up a many-to-many relationship through a pivot table, where, for example, one is able to set groups of highlighted products.

I have the tables: highlights, products, and highlight_product.

In my HighlightCrudController, I have added the field:

        $this->crud->addField([
            'name' => 'products',
            'label' => 'Products',
            'type' => 'select2_multiple',
            'entity' => 'products',
            'pivot' => true,
        ]);

The Highlight model has the function:

public function products()
{
  return $this->hasMany(Product::class);
}

The Product model has the function:

public function highlights()
{
  return $this->belongsToMany(Highlight::class);
}

When saving, I get an Illuminate \ Database \ QueryException - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'products.highlight_id' in 'where clause'.

I can see it is trying to update the products table rather than the pivot: update 'products' SET 'highlight_id' ...

I'm just curious what I'm doing wrong here?

[pxpm]

Hey @alancwoo when using a pivot table both relations should be belongsToMany and not hasMany.

Cheers

[alancwoo]

Oh I see, that works, thank you!

[jcastroa87]

I'm closing this issue due to inactivity. If you need further assistance or have additional questions, feel free to reopen this issue or create a new one. We're here to help!