search for foreign key using multiple columns

    public static function form(Form $form): Form
    {
        return $form
            ->schema([
                Select::make('inventory_id')
                ->relationship('inventory', 'productName')
                ->relationship('inventory', 'barcode')
                ->relationship('inventory', 'partNumber')
                ->searchable()

            ]);
    }