The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Generate cities form country
Posted: 29 May 08 5:57 AM
|
Dear All
When I choose country from Picklist or combobox, it generate its cites in city picklist or combobox.
How can I do this? |
|
|
|
Re: Generate cities form country
Posted: 29 May 08 6:12 PM
|
Sounds like you want to implement a hierarchical picklist. It's not as easy as it could be, but have a look at the code behind Account Type and SubType on the Account Detail form. The subtype picklist depends on the Account Type selected - so you could use the same technique.
Phil |
|
|
|
Re: Generate cities form country
Posted: 01 Jun 08 3:04 AM
|
Thank you
But I need to do it for "Countries" and thier "Cities"
If I use the same technique, I have a lot of countries so it will be diffecult to do this for all countries.
What I think for is to set a table contains Countries and other for thier Cities and relate the two tables to each other and then generate a code for this, so I want you to help me in this code. |
|
|
|
Re: Generate cities form country
Posted: 01 Jun 08 4:49 AM
|
What you are talking about is completely feasible - and even a good idea. But it's quite a lot of work to implement.
On the database side - pretty straightforward - two tables as you suggest.
But then you need to build a maintenance facility (so that administrators can add/edit/delete entries). Then you need to decide what happens to the underlying data if the picklist entries are edited or deleted - and code it.
After that, you need to build the selection logic into your combos - picklists will not work in this scenario.
It's quite a big topic - you will have to be more specific with your questions, as just asking for help is a bit too general.
Phil
|
|
|
|
Re: Generate cities form country
Posted: 01 Jun 08 5:12 AM
|
Thank you
On database side - It is ok, I'll create the two tables and manage them
On Code side I need your help in coding combos. because I'm not professional in saleslogix coding. |
|
|
|
Re: Generate cities form country
Posted: 01 Jun 08 5:31 AM
|
OK, go ahead and build/populate the tables.
You will also have to add the appropriate fields to the tables in which you want to store the data.
Then I can help you with the code to populate the country combo. We'll take it from there. |
|
|
| |
|
Re: Generate cities form country
Posted: 02 Jun 08 11:17 AM
|
Originally posted by Enjy
Okay I add the tables and add fiew data
I'm waiting for code. |
|
Hi Enjy,
I wouldn't wait too long for the code  , this is a forum of people trying to help each other, but we all have jobs. You can always expect good help from these forums, but you shouldn't expect the forums to provide everything for you. We'll get you started, but doing the job is up to you (or another business partner you'll hire to do the work for you). If you're not capable of actually writing the code, you'll probably not get too far here and will want to look into
1) Training
2) Outsourcing to another business partner
Not trying to discourage you or anything, we're all here to help, just not to do the job for you 
Good luck.
-Ryan |
|
|
|
Re: Generate cities form country
Posted: 02 Jun 08 2:45 PM
|
Thank you ryan
I'm .net developer and I know that these forums is for trying to help, I accept this, in other forums I help by code who cann't write code, and I'm aslo busy, but this does not prevent me to help any one.
Thank you any way for your support. |
|
|
|