-- here's something I use in an SSRS report to pull based on prompt for schema keyword.
SELECT [name],[schemaid] from [dbo].arschema where [name] like '%' + @schemasearch + '%' order by [name]; SELECT [fieldname],[fieldid] FROM [dbo].[field] where [schemaId] = @schemaname and [dataType] = 6 and not fieldname like 'z1%' and not fieldname like 'zD%' order by fieldname Regards, Andrew C. Goodall Software Engineer Development Services [email protected] jcpenney 6501 Legacy Drive Plano, TX 75024 jcp.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of vidyasagar kommu Sent: Tuesday, May 15, 2012 5:24 AM To: [email protected] Subject: how to get the values instead of ID's in the Database table Hi All, I have 1 Mainform and 3 other regular forms mapped with the fields of Main form respectively on the basis request id of other regular form. The mapped fields have menus attached to it. I can see the values properly in the Main form. But in the Database of Main form I am unable to see the values and I am getting the ID's on the fields related to Othere regular forms. Please let me know how to get the values instead of ID's in the Database table( Main Form)? Thanks Sagar _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
