How to dynamically load data in picklist?

Hi,
 
I have two quries.
 
On a tab of my MSCRM application, i want to display a drop down which
will display data depending on selection of another picklist.

I want to display data from a table of database, in other words i want
to read data of picklist at runtime from a CRM table.
 
Kindly tell me what will i have to do, and how to incorporate these
changes.

Thanks in advance
0
sfarhad
10/19/2004 10:14:10 AM
crm 35858 articles. 1 followers. Follow

1 Replies
735 Views

Similar Articles

[PageSpeed] 53

If this picklist is on an original CRM form using CRM picklists, then its
impossible. Only way is to create your own form and add it to the CRM
form,....then its basic programming.....

-gary

"Farhad" <sfarhad@gmail.com> wrote in message
news:6f6afb78.0410190214.5030ee52@posting.google.com...
> Hi,
>
> I have two quries.
>
> On a tab of my MSCRM application, i want to display a drop down which
> will display data depending on selection of another picklist.
>
> I want to display data from a table of database, in other words i want
> to read data of picklist at runtime from a CRM table.
>
> Kindly tell me what will i have to do, and how to incorporate these
> changes.
>
> Thanks in advance


0
Gary
10/19/2004 3:07:46 PM
Reply:

Similar Artilces:

Where is the data menu for sorting lists?
Am trying to sort an address list into alphabetical order. Help says click on list and and select from data menu. When i click no data menu appears. can anyone help please? Thank you. Do you want to tell us what Office program you're referring to, and what version of that program? Daddy "Shakoh" <Shakoh@discussions.microsoft.com> wrote in message news:7E04A2BD-DA32-462B-A912-5469035351C9@microsoft.com... > Am trying to sort an address list into alphabetical order. Help says click > on > list and > and select from data menu. When i click no...

How can stop excel from autochanging my cut and paste data?
Recently I need to copy and paste some data in to my excel for references. However, whichever part I copied containing text like 1-0, 1-2 the text will automatically change to 1/1/2000, Jan 2 etc.... Why is it so? How can I stop that? But when I try to reformat cell to text it becomes code numbers like 36586. Help me please. Thank you. p/s I paste the text in HMTL form if I paste special as unicode text. Hi Try pre-formatting the column as Text. Format>Cells>Text -- Regards Roger Govier "Excel doubter" <Excel doubter@discussions.microsoft.com> wrote in messag...

XML Map
Hi all, I import XML data into a worksheet, and choose a mapping name, but I have no idea how to change the path so that it is dynamic. I've been trying to find a way to set my mapping paths to dynamic, so that when I move the folder that contains the xl file and xml files, the mapping path still works. Help :) Cheers, Grant. I'm not sure you can make it 'dynamic' per se but you can write code to change. Here's a sample of changing the bound xml document. ActiveWorkbook.XmlMaps(1).DataBinding.LoadSettings ("C:\Services Proposal.xml") -- Charles...

Separate data string into numeric and text
Hi Can anyone help me with a script, to read in a string of mixed numerical and text data, and separate them to a specific format of spacing. This is the raw data: 11-11-11,44444444,JOE R BLOGGS,2757.42, I need to convert the data into 11111144444444JOE R BLOGGS 2757.42 Firstly i need to remove the "-" and ",", so that it all joins up. There needs to be 6 chars at the start for 111111. At the 7th char i need to leave space for 8 digits (44444444 - although sometimes the no. being read in will be less than this). Then 15 chars must be left for name, and the amount will...

refer to data on multiple worksheets using hlookup/look up data on many worksheets?
Hi I have data on many worksheets in the same workbook. Is it possible to look up data on multiple worksheets using Hlookup, which means can the second argument in the formula refer to multiple sources? If it is not possible, is there any other way I can do so? I would like to select and display data according to a fixed order, whereby the data is located in one of many worksheets in the same workbook. For eg, I have stock returns of many firms in many worksheets. Say I would like to display in a single worksheet the returns of Firm D, Firm Z, Firm R; whereby the data of these 3 fir...

Making sure data is saved on closing application
Hi, I have built myself the following application from 'Teach Yourself Visual C++ in 21 Days' chapter 'Day 14 - Retrieving Data from an ODBC Database' http://serghei.net/docs/programming/c++/ty%20visualC++6%2021%20days/ch14/ch14.htm The application lets you edit and add records to a database (as well as just retreive them). The application uses recordset flags in code to make sure that data is saved if you edit one record and move to another. However, there is no code to make sure new or edited data is saved when the application is exited. After having poked about, I have...

Problems XSLT Transformation of XML Data to EXCEL 2000
Does Office Excel 2000 support XSLT transformation of data from XML cause am having problem when the attachment is opened in the client side if the Excels version is in Office 2000 and also its works fine if the Office Excel Version 2002 and up when attachment file is open via browser the data is in a single line of string in the first row of the excel worksheet Glenn Gomez wrote: > Does Office Excel 2000 support XSLT transformation of data from XML cause am > having problem when the attachment is opened in the client side if the Excels > version is in Office 2000 > >...

How to access data buffers in a completion routine for a KMDF driv
I'm porting a WDM upper filter driver to KMDF version. I have two questions about data accessing in a completion routine. 1. In the completion routine of my WDM upper filter driver, it was able to retrieve data from Irp->AssociatedIrp.SystemBuffer( The IRP is using Method Neither I/O, and the data was set by function driver). How to do this for my KMDF driver? 2. In the completion routine of my WDM upper filter driver, it was able to retrieve data by calling MmGetSystemAddressForMdlSafe(Irp->MdlAddress, NormalPagePriority)( The IRP is using Method Neither I/O, and t...

Expense data base
does anyone have a database to track household expenses (utilities, insurance, etc.) http://office.microsoft.com/en-gb/templates/TC102068841033.aspx?CategoryID=CT101428511033&av=ZAC000 Or http://www.microsoft.com/money/default.mspx -- Kevin3NF SQL Server dude You want fries with that? http://kevin3nf.blogspot.com/ I only check the newsgroups during work hours, M-F. Hit my blog and the contact links if necessary...I may be available. "cg" <cg@discussions.microsoft.com> wrote in message news:A799A57F-0129-408E-80A8-346685F420F3@microsoft.com... > does anyone h...

Automatically moving data #4
Thanx for all the help. I'm going to make the file smaller first. Where do I email it to -- multipla ----------------------------------------------------------------------- multiplan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1591 View this thread: http://www.excelforum.com/showthread.php?threadid=27391 Thought I gave you this reply earlier ?? Either to: xdemechanik <at>yahoo<dot>com or demechanik <at>yahoo<dot>com (both valid) -- Rgds Max xl 97 --- GMT+8, 1� 22' N 103� 45' E xdemechanik <at>yahoo<dot>...

Faulting application dynamics.exe
I am not sure what is going on but there are times when this error occurs for users in GP 7.5... "Faulting application dynamics.exe, version 7.5.0.3, faulting module mfc42.dll, version 6.0.8665.0, fault address 0x000048ab." After getting this error, GP shuts down. I have been trying to pinpoint when it does not happen in a consistent spot. It also does not happen to all users. I also can not get this error to occur on the development machine. I have researched the heck out of this on the web but have found no resolution. The only thing that I can see different is the deve...

Automating transfer of data in cells
I have a time management spreadsheet with data stored against work type and date. I need to transfer this data into a similar but more comprehensive spreadsheet and wonder whether it is possible to automate this task by using the work types and dates in a macro (I have almost 10 months of data to transfer), along the lines of check date, check worktype, where argument is true enter data from cell. I think I need to use visual basic, but I can't find out how in the help screens. Any advice is much appreciated. This is not difficult providing you keep your data in simple tables...

CRM 4.0
Hi How does one configure a WF Local Service / Data Exchange Service in CRM 4.0? In a custom WF host I can accomplish this by specifying the service in the host application's configuration file. Is this approach possible with CRM 4.0? I understand that the workflow runtime is hosted by the CRM Asynchronous Service, and I have been able to register custom WF Activity as detailed in the CRM SDK documentation. However I can find no references to registering / configuring a local service. Any help much appreciated! Regards, Gareth On Oct 23, 1:38=A0pm, rgdav...@gmail.com wrote: > H...

Saving data #2
Hi all, I need to save data (results) from a base spread sheet program that i use on a weekly basis. i am in the middle of building this program, and have just discovered macros, but this, along with links is about my current knowledge of excel how can i automate to accumulate data from the base spread sheet (program) when i clear all data from the program to produce fresh results the following week, and to keep past data up to date and available for further use. Any help would be appreciated. legepe With a combination of formulas and dynamic named ranges, it is possible to just add the ...

Importing data via macro
Hi, I want to create a macro, which let me automate the process of importing the data from various files (*.xls) from a particular directory to the main table in MS Access. My Main table in access is called Wire Transfer Main table. And every Monday few specialist go in a share drive and post their completed forms in ..xls format. My macro should go into that shared directory every week and pull out the files from that directory and copy the data from those files to my Wire Transfer Main Table in access database. Please help. Thanks Liz - you're probably better off if you writ...

Adding data from another sheet.
I hope I can find some help on this one. I have a spreadsheet that consists of two sheets. The first is a form. The second is a list of questions. I have added a checkbox next to each question on sheet 2 to select the question and add it to the form on sheet 1. The problem: when you select a question on sheet 2 it will only add it to a specific cell on sheet 1. So if I select question 15 it will go in a position like it is the 15th question when actually I would like it to be the first question. The question: Is there a way to make the questions start adding to the top cell on sheet 1...

Get Access Data into Excel
Hi All, I am using excel macro to get data from access database. My sql query gives me 5 records or more than that. I am able to pull it different cells. But I want all the 5 results in single cell. Please help im not exactly sure what your trying to do, but maybe something like this will do the trick dim accval as string accval=rs!:XXX rs.movenext accval=accval & " " & rs!:xxx loop it till rs.eof=true hth dmoney "fi.or.jp.de" wrote: > Hi All, > > I am using excel macro to get data from access database. >...

Drill down pivot table data via VBA macro
I am trying to create a macro that will drill down subtotals from a pivot table. Since the number of rows, and colums, changes frequently I need to reference the total for the row or column. Can this be done via VBA macro? -- jmon76 ------------------------------------------------------------------------ jmon76's Profile: http://www.thecodecage.com/forumz/member.php?u=1909 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=204538 http://www.thecodecage.com/forumz Excel 2007 PivotTable Show subtotal details via macro. Define subtotal with PivotField...

Cut'n'Pasting data
Greetings ! I have a CSV data file wot looks something like this - "1529.17698720957","133.597550559965" "1685.21901149326","132.817184396522" "1900.00000000000","130.300887834893" "2193.34485206410","121.730777157435" "2363.17295960769","114.937652855693" "2523.01169878763","108.544103288496" "3240.77088467590","87.805735336415" "3590.69860622591","81.680775462264" "4229.19543928027","78.487652800160" This data i...

Help Fixing Data on Item Stock Status display
GP 8.0, SQL Had an employee "sell" 9,000,000,000 units of an item at $0 price. Instead of deleting the line, he $0 the price. The invoice was posted. I discovered when our income statement showed a loss of $42b! My first mistake was to try and reverse by creating a return for the same # of units at $0 price. But somehow this created problems with the inventory. Basically, I messed around with it with a number of invoices/inventory adjustments. I discovered how to void the RTN and INV using utility > sales > remove sales history. This had the desired effect with one exc...

Data from Form to Subform to Table
I have a main form for material inspection, and another form for the inpsection results, and tables for each that store the data. For example, you have to enter the PO# and P/N on the main form, as well as some other info, then you click to open up the inspection results form in datasheet view. The inpsection results form shows the PO# and P/N that you entered on the main form, but it wont store the info in the table for the inspection results. Can someone please help me figure out how to get the info to store in the inspection results table as well as the material inspection tab...

Fuzzy matching data
Hi I have two spreadsheets of similar property data, and Im trying to create a formula in spreadsheet A that will look in spreadsheet B, find the matching property data then return corresponding data to spreadsheet A. Im using the Index formula for this and name ranges, and everything works fine if the property data in spreadsheet A exactly matches spreadsheet B. If there is a slight difference it falls down e.g. spreadsheet A property named '28 St Marks House', spreadsheet B property named 'Flat 28 St Marks House'. Does anyone know of a matching/lookup/index method that...

How can I automatically remove duplicate data within a column?
Is there a way to automatically remove duplicated data within a column in Excel? For example, I have a column of over 10000 rows. The cell contents are call numbers, many of them are duplicate and I'd like to remove them without sorting and manually removing them. Chip Pearson has a means for doing this at http://www.cpearson.com/excel/deleting.htm If it is just a single column, though, you can use Data>Filter>Advanced Filter. Once there, select Copy to a new Location and Unique Records only. That will give you a list of unique values in your column - i.e., no duplicates...

Whats the fastest way to retieve data in asp.net using MySql
I know this is not a MySQL forum, but we use ASP.NET and MySQL. My questions is what is the fastest, most efficient way to retrieve data using asp.net using MySQL 5? thanks in advance Are you referring to ODBC/OLE DB connection settings, how to write SQL queries, embedding queries in the asp.net pages, or calling stored procedures? I'm sorry, but your question is just too vague. Perhaps if you explained why you're asking the question and why you're asking it in a SQL Server group. FWIW, generally connecting async and writing stored procedures for ever...

OFFSET problems in dynamic range
Hi, I'm having the strangest problem with the OFFSET function. I have 5 dynamic ranges in my worksheet. Aimline =OFFSET('Weekly ORF'!$F$4,1,0,COUNTA('Weekly ORF'$F:$F)-1,1) Sessions =OFFSET ('Weekly ORF'!$D$4,1,0,COUNTA('Weekly ORF'$E:$E)-1,1) WCPM =OFFSET ('Weekly ORF'!$G$4,1,0,COUNTA('Weekly ORF'$G:$G)-1,1) Date =OFFSET ('Weekly ORF'!Aimline,0,-1) Date2 =OFFSET ('Weekly ORF'!WCPM,0,-1) The problem is that the two names for Date and Date2 keep reverting to =OFFSET ('Excel Template.xls'!Aimline,0,-1) and =OFFSET (&#...