Hi,
I'd like to achieve the following
A user registers via the normal Joomla registration. Now he ist in status Registered. this works already
By filling in more details in a Fabric form he can become a "Requestor".
To become a Requestor the user needs to choose a so called "Sponsor" from a dropdown list.
All users can become a Sponsor but this is done with a manual assignment by the admin via the "sponsors" form.
I have a list/form called "sponsors" with an element (sponsor_name) using databasejoin to take a full_name from a table of existing "Requestors". In total this list only has three elements - date_time, id and sponsor_name (Value = ID , label = full_name).
Another list/form which makes the user a "Requestor" is also using databasejoin and is supposed to show the list of full_names in this form as a dropdown list. Here I used Value = ID and label = sponsor_name
Now the problem is that always only the ID shows up in the dropdown list and i cant show the sponsor_name.
Where is the problem in your eyes?
I'd like to achieve the following
A user registers via the normal Joomla registration. Now he ist in status Registered. this works already
By filling in more details in a Fabric form he can become a "Requestor".
To become a Requestor the user needs to choose a so called "Sponsor" from a dropdown list.
All users can become a Sponsor but this is done with a manual assignment by the admin via the "sponsors" form.
I have a list/form called "sponsors" with an element (sponsor_name) using databasejoin to take a full_name from a table of existing "Requestors". In total this list only has three elements - date_time, id and sponsor_name (Value = ID , label = full_name).
Another list/form which makes the user a "Requestor" is also using databasejoin and is supposed to show the list of full_names in this form as a dropdown list. Here I used Value = ID and label = sponsor_name
Now the problem is that always only the ID shows up in the dropdown list and i cant show the sponsor_name.
Where is the problem in your eyes?