Combobox Selection from Sql
-
Hi All Im trying to make an address look up application using sql. I want it so that when the user selects a country the window will change and match the country Address Formart. For Example if i choose UK from the combobox the form will change to this address formart : Building Road Town PostCode United Kingdom but if i click USA Holtsville NY 00501 United States How can i achieve this...
-
Hi All Im trying to make an address look up application using sql. I want it so that when the user selects a country the window will change and match the country Address Formart. For Example if i choose UK from the combobox the form will change to this address formart : Building Road Town PostCode United Kingdom but if i click USA Holtsville NY 00501 United States How can i achieve this...
create the maximum number of different textboxes you need, then assign them a number each i.e. TBLine1 = 0 TBLine2 = 1 TBCity = 2 TBRegion = 3 TBPostcode = 4 TBCountry = 5 Then in your database you have a list of countries and also a column with the order the address should be displayed split with a non numeric character, i.e. UK 0;1;2;3;4;5 USA 2;3;4;5 Then you can parse the column and dynamically set the location of the fields based on the ordering
My opinion is... If someone has already posted an answer, dont post the SAME answer
-
create the maximum number of different textboxes you need, then assign them a number each i.e. TBLine1 = 0 TBLine2 = 1 TBCity = 2 TBRegion = 3 TBPostcode = 4 TBCountry = 5 Then in your database you have a list of countries and also a column with the order the address should be displayed split with a non numeric character, i.e. UK 0;1;2;3;4;5 USA 2;3;4;5 Then you can parse the column and dynamically set the location of the fields based on the ordering
My opinion is... If someone has already posted an answer, dont post the SAME answer