I have a form with lookup field type. How do I populate list of site subcribers into drop down choice for this field? Thanks!

Thank you for your reply. How would you solve this issue? I need to populate a drop down box that is a part of form field with a list of DNN registered users. Is there another module you would recommend for this?

Hi Stefan

I read your answers with interest regarding populating a drop down list within "Form & List"  - Tricky if not impossible at this time.

I have a slightly different requirment to JakeMan35, i want to simply populate a drop down list (in FnL)  using the country values in the "Lists" table.

Countries rarely change names unless there is a coup attempt or whatever... i know i can populate the DDL manually, however all ~250 countries will not fit in to the input box for the drop down list. I had been using DataSpring "Dynamic Forms" which has a specific "DNN Country" dropdown, however Dynamic Forms has driven me near madness and i am finished with using their products. anyway i digress.

Form and List is simple and easy to work with, however i can not seem to populate a dropdownlist from the Lists/Country table in the database.
Here is the snippet of SQL i want to use - but Oh where to put it :)

SELECT Text FROM dbo.lists WHERE ListName = 'Country';

Any ideas would be gratefully received.