I would choose Advanced SQL query as a source for a dropdown.

SELECT RoleName
FROM dbo.Roles

Thank you this has helped me make progress i have never used SQL (I have jumped in head first) and after finding the SQL Console i was able to make this work. I do still have one issue i do not understand yet. The drop down has nothing listed but if you click the box the role will pop up then disappear and unclick the box. I also did figure out using the WHERE will allow you to pick what roles to be displayed.

 

It would help to see you SQL query and also a screen shot of the configuration of the dropdown.

I think that the two LinkTo entries are wrong. Try setting them to nothing and see if that helps. (And ... I'm doing this from memory so I could be wrong.)

I think Joe is right. If I try:
SELECT RoleName
From Roles
WHERE RoleName IN ('registered users', 'subscribers')

this populates the dropdown correctly. So, without LinkTo fields.

Now, what may come in handy is to adjust the SQL to:
SELECT RoleName, RoleID
From Roles
WHERE RoleName IN ('registered users', 'subscribers')

The first part of the select is what is the name in the dropdown. The second is the value, in case you need the RoleID somewhere else. So, it's the same is if you would use the datasource items and fill them like registered users|2 for instance.

Thank you guys tons its working correctly now that i deleted the LinkTo and wrote the SQL as instructed. I still have the issue of the roles not showing up in the drop down menu, after i changed the theme you can see them. Thats clearly  the EasyDNN theme and Action Form not working together well. Thanks a ton!!!!

 

Was able to change the font color in the dropdown by: Style Wizard->Theme->Open Action->Edit Style->Fonts->Content->Color

Posted By Justin15 on 07 Sep 2020 05:56 PM

Thank you guys tons its working correctly now that i deleted the LinkTo and wrote the SQL as instructed. I still have the issue of the roles not showing up in the drop down menu, after i changed the theme you can see them. Thats clearly  the EasyDNN theme and Action Form not working together well. Thanks a ton!!!!

 

I never experienced collissions between EDN and DNN Sharp modules but both of them offer great support.