relationshipmanager for belongsToMany relationship with pivot table tries to insert into wrong table

Hey guys might there be any reason that a relation manager tries to insert into the relation table instead of the pivot table?

I currently have usersrelationmanager that is tied to courseresource. my course and users do have many-to-many relationship with a pivot table. inside usersrelationmanager, i have my relationship set to 'users', but when i try to add a new student for a course, it tries to insert an item to the users table...

class UsersRelationManager extends RelationManager
{
    protected static string $relationship = 'users';

    protected static ?string $modelLabel = 'Student';

    protected static ?string $title = 'Enroll Students';

    protected static ?string $recordTitleAttribute = 'id';

    public static function form(Form $form): Form
    {
        return $form
            ->schema([
                Select::make('user_id')
                    ->label('Student')
                    ->required()
                    ->options(function (RelationManager $livewire): array {
                        // code to get the users
                    })
                    ->searchable(),
            ]);
    }

class UsersRelationManager extends RelationManager
{
    protected static string $relationship = 'users';

    protected static ?string $modelLabel = 'Student';

    protected static ?string $title = 'Enroll Students';

    protected static ?string $recordTitleAttribute = 'id';

    public static function form(Form $form): Form
    {
        return $form
            ->schema([
                Select::make('user_id')
                    ->label('Student')
                    ->required()
                    ->options(function (RelationManager $livewire): array {
                        // code to get the users
                    })
                    ->searchable(),
            ]);
    }

when i try to create a new entry, the realtionshipmanager tries to insert into the users table instead of user_courses table

relationshipmanager for belongsToMany relationship with pivot table tries to insert into wrong table

class UsersRelationManager extends RelationManager
{
    protected static string $relationship = 'users';

    protected static ?string $modelLabel = 'Student';

    protected static ?string $title = 'Enroll Students';

    protected static ?string $recordTitleAttribute = 'id';

    public static function form(Form $form): Form
    {
        return $form
            ->schema([
                Select::make('user_id')
                    ->label('Student')
                    ->required()
                    ->options(function (RelationManager $livewire): array {
                        // code to get the users
                    })
                    ->searchable(),
            ]);
    }

class UsersRelationManager extends RelationManager
{
    protected static string $relationship = 'users';

    protected static ?string $modelLabel = 'Student';

    protected static ?string $title = 'Enroll Students';

    protected static ?string $recordTitleAttribute = 'id';

    public static function form(Form $form): Form
    {
        return $form
            ->schema([
                Select::make('user_id')
                    ->label('Student')
                    ->required()
                    ->options(function (RelationManager $livewire): array {
                        // code to get the users
                    })
                    ->searchable(),
            ]);
    }

when i try to create a new entry, the realtionshipmanager tries to insert into the users table instead of user_courses table

relationshipmanager for belongsToMany relationship with pivot table tries to insert into wrong table

Similar Threads

relationshipmanager for belongsToMany relationship with pivot table tries to insert into wrong table

Similar Threads

Similar Threads

Similar Threads