Hello there, first of all I absolutely love j-cook, what a time saver!

I have a question regarding select lists populated by an sql query in the forms.

I am accustomed to using JForm, where there is a type of "sql".
I am trying to populate the list from another table, I tried using the foreign key field, but it is just a text field.

Any pointers?

Thanks