valuelist.ini problem

[samhans]

hai friends
my problem is now with the dynamic valulist.ini file. actually i have two tables one named user_details and other is loan_cardholders .

in the user_details {userid,serno,name} and in loan_cardholders {loanid , serno } fields are there.

i want to make a valuelist in the loan_cardholders such that in the form user could select the serno from the available users in the user_details table.

for this i have created the valuelist.ini file in the loan cardholders table. with code
[users]
__sql__="select serno,name from user_details order by name"

in the fields.ini file i wrote the select widget and vocabulary is users.

but after that i can see the drop down but blank, without any value .

please help. where am i wrong.

[shannah]

sounds like it's not finding your valuelist. Where is the valuelist defined? (it needs to be either in the main application valuelists.ini file or the table that has the select list).

Also double check that you are referencing the correct valuelist name in your vocabulary directive (case sensitive).

_Steve