Form select relationship help

I have a user which can have a

resource_no

resource_no

resource_no

resource_no, that points to the resources table however we do not use the ID, it points to the resources

no

no

no

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'),

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

resource.no

resource.no

resource.no, but when I do that I get

Unknown column 'resource' in 'field list'

Unknown column 'resource' in 'field list'

Unknown column 'resource' in 'field list'

Unknown column 'resource' in 'field list'