6/18/2025 1:29:39 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
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!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
picklists
Posted: 21 Apr 07 10:51 AM
|
fiogf49gjkf0d Dear all
Can any body help me in coding small logic
Actually in address window i need to restrict picklists such that if a country called india only indian states have to be there in state picklist, if i select U.A.E only U.A.E emrites has to be there in that states picklist
pls help me on this issue
with regards
vamsi
|
|
|
|
Re: picklists
Posted: 23 Apr 07 7:53 AM
|
fiogf49gjkf0d The first thing you have to do is add a custom field that will link the state to the country. Since the country and state lists are in the picklist table this would probably be best done by create another picklist that joins the two picklists together.
Once that is done the rest is done by modifying the SQL statements to filter out the state data based on the currently select country using the custom picklist. If no country is selected, then the SQL should return all states.
John G. |
|
|
|
Re: picklists
Posted: 23 Apr 07 9:57 AM
|
fiogf49gjkf0d Since this list probably will go quite large, depending on the number of states and countries involved, picklists may not be the solution to use. It might be better suited for you to utilize a seperate table for this. There is a standard table called POSTALCODE that could be used. You would need to enter a rwo for each state that has the corresponding country. Once this data is entered, you could then utilize a combo box and populate that at runtime or use a lookup and restrict the lookup results based on the country selected. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|