Select2 fields MySQL

Please help me i am new to select2 …
Have a project with PHPMaker2021 to fill in a match form (e.g. fields cardno, name, club) found in database MySQL with a view (vwnat).
In the new version, select2 is apparently needed instead of normal select.
I suppose I need to create a select html element in my custom template.
My primary key in my view is cardno. So as soon as I enter cardno (lookup link field) it looks up the record of this cardno.
Actually I want a select2 with as output the fields cardno, name and club from my view (vwnat).
Hopefully you can give me some examples or whatever, thank you anyway

i think i accidentally clicked dismiss yesterday …
I did create an account yesterday
Hopefully someone can help me with the question below.

Please help me i am new to select2 …
Have a project with PHPMaker2021 to fill in a match form (e.g. fields cardno, name, club) found in database MySQL with a view (vwnat).
In the new version, select2 is apparently needed instead of normal select.
I suppose I need to create a select html element in my custom template.
My primary key in my view is cardno. So as soon as I enter cardno (lookup link field) it looks up the record of this cardno.
Actually I want a select2 with as output the fields cardno, name and club from my view (vwnat).
Hopefully you can give me some examples or whatever, thank you anyway