Here is my proplem. There is a main form (frmMain). There is a text box (edtOrderNumber). When you enter whole order number (99000123) or just a part of it (123) it searchs the mysql database and returns the value. if it finds only one result it fills all fields like edtBillingName, edtBillingSurname etc. The thing I want to do is if it finds more than one result it will open a new form (frmFoundOrders) with a ListView on the form (lvFoundOrders) and show all found results on this new form with OrderNumber and CustomerSurname values. When user clicks on one of these results this form (frmFoundOrders) closes and the ordernumber value passes to main form (frmMain) and fills the fields (edtBillingName, edtBillingSurname etc. ).
I could manage to do if the result just one.
As you can understand I'm trying a develop the admin page of our ecommerce site on Delphi 7. Order numbers are uniqe.
Thanks in advance for your help.