F
Filament•2d ago
delboy1978uk

Form select relationship help

I have a user which can have a resource_no, that points to the resources table however we do not use the ID, it points to the resources no column, however my select inserts the ID, can anyone help? 
Select::make('resource_no')
    ->relationship('resource', 'name'),
Select::make('resource_no')
    ->relationship('resource', 'name'),
I tried changing the name of the select to use the dot notation to resource.no, but when I do that I get Unknown column 'resource' in 'field list'
4 Replies
Mohamed Ayaou
Mohamed Ayaou•2d ago
you should've setup the relation in the model class to set the primary key and the relation name
delboy1978uk
delboy1978ukOP•2d ago
Hi @Mohamed Ayaou so in my User class I have this : 
    public function resource(): HasOne
    {
        return $this->hasOne(Resource::class, 'no', 'resource_no');
    }
    public function resource(): HasOne
    {
        return $this->hasOne(Resource::class, 'no', 'resource_no');
    }
And in my Resource class I have this: 
    public function user(): BelongsTo
    {
        return $this->belongsTo(User::class, 'resource_no', 'no');
    }
    public function user(): BelongsTo
    {
        return $this->belongsTo(User::class, 'resource_no', 'no');
    }
The resource_no as I say is on the users table, and points to the no of the resources table its also nullable if that makes a difference? although no error is thrown so probably not
Mohamed Ayaou
Mohamed Ayaou•2d ago
not sure from the first insight but try to dd($user->resource), dd($user->resource_no), and dd($user->resource->no)
delboy1978uk
delboy1978ukOP•2d ago
where should i try the dump? if i change the db value to the no instead of the id, in my table of users, a text column resource.name works, so i imagine the relationship is ok? the has one and belongs to were the wrong way around! thanks for your help

Did you find this page helpful?