IVisualise
Technical User
Hi,
I'm having trouble performing what might just be a simple task. I'll explain.
I have a form where I enter a company name partially in a text field. What I want to do is to click a button next to the text field and have it open another window. There I would like to run a SQL query to search for all reocrds that have a company name similar to the one entered. Once that is done, it would diplay all the records in table format, and will allow me to select one of them.
When selected, it would close this window and fill in the other text fields in the first window with the results of the query.
Someone told me that I can use showmodaldialog window. I've done this. But I don't know how to pass the variable to the window and then run the query using the variable passed. And then pass the results back into the first window.
I hope you understand this long story. Can you please help?
Thanks a million in advance.
I'm having trouble performing what might just be a simple task. I'll explain.
I have a form where I enter a company name partially in a text field. What I want to do is to click a button next to the text field and have it open another window. There I would like to run a SQL query to search for all reocrds that have a company name similar to the one entered. Once that is done, it would diplay all the records in table format, and will allow me to select one of them.
When selected, it would close this window and fill in the other text fields in the first window with the results of the query.
Someone told me that I can use showmodaldialog window. I've done this. But I don't know how to pass the variable to the window and then run the query using the variable passed. And then pass the results back into the first window.
I hope you understand this long story. Can you please help?
Thanks a million in advance.