I have a link setup to a SQL server and I am looking to display certain information in seperate text boxes dependant on a selection further up in the form.
I have setup a rule on the database field that i am trying to show in the text boxes so that if it is equal to the drop down selected above then it will display but it only displays the first item on the list in every box. Is it possible to somehow tell it to show the first item from the list on the server in the first box then the second in the second box etc.
Finding it a bit hard to explain this one sorry, so if anything needs to clarified please let me know.