https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-parameters-based-on-PK-ID-of-a-table/m-p/7530#M2382 It sounds like you want to have a display name and an actual value for each item in the list. <BR /> <BR /> You cannot do this in the query builder with project parameters, but it is supported when you create a stored process. In our next release, this is supported with the new project prompts.<BR /> <BR /> Chris Sat, 22 Mar 2008 18:10:00 GMT ChrisHemedinger 2008-03-22T18:10:00Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-parameters-based-on-PK-ID-of-a-table/m-p/7529#M2381 Is there a way to create a parameter in the parameter builder where you can base the parameter list on names but use the id of that name in a query filter. Example; I have a table called Methods. Each method has an int ID and a string Name. I want the Name to show up in the prompt for the parameter, but when a user selects the name I want the ID to be used for the filter in the query. Mon, 17 Mar 2008 19:18:54 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-parameters-based-on-PK-ID-of-a-table/m-p/7529#M2381 macroCharlie 2008-03-17T19:18:54Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-parameters-based-on-PK-ID-of-a-table/m-p/7530#M2382 It sounds like you want to have a display name and an actual value for each item in the list. <BR /> <BR /> You cannot do this in the query builder with project parameters, but it is supported when you create a stored process. In our next release, this is supported with the new project prompts.<BR /> <BR /> Chris Sat, 22 Mar 2008 18:10:00 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-parameters-based-on-PK-ID-of-a-table/m-p/7530#M2382 ChrisHemedinger 2008-03-22T18:10:00Z