read db

hello, I have a data entry form. I have a dropdown that reads data from a table with Autocompleter. The table has two fields "agent" and "shop". An agent manages more shops, I wish in the agent base that fill out the form only appear its shops in the dropdown. How can I do ??
It may be useful to life inside there is already a feature that identifies who is filling out the form and then send an e-mail notification. thanks

Hi agostino87,

I think that all of the form data is sent back to the autocompleter so if you have the Agent ID in a hidden value you can use that in the autocompleter code to look up the values for that Agent ID

Bob