Re: how to get the values instead of ID's in the Database table
Hi, I think we are overcomplicating things. I have read between the lines here, and think that Sagar is talking about a simple multi-tier search-type char-menu... You should give us detailed examples, otherwise we can never help you. This could be your setup: FormProductCat: FieldProdCat (6) FormProduct: FieldProdCat (6) FieldProduct (6) FormWhereUserInteractsWithMenu: FieldProdCat (536870913) FieldProduct (536870914) <-- this is where my Menu goes So how do I construct a search-menu for the field 536870914? Menu that searches in FormProduct: ('FieldProdCat' = $536870913$) I hope this answers your question. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > Hi Ann, > > In the main form i have filed "A" this field A is dependent on > prooduct and producttype value when the user select product and > product type value so i need to pass the product and product type > dynamic values to another form i.e regular form for getting the Field > A value for this approach i used Search menu. > > Another form filed B( B filed also dependent on product and product > Type) based on the user selection of A filed value it should derived > B filed value. > In this form i have CReated A filed and accordingly i have mapped > with B filed data In this approach getting the values i am using > Serach menu.in the search menu qulication i have given Database ID of > the main form Filed A Id and product and product Type Id's. > > Thanks > Sagar > > On 5/15/12, Ann Ctl wrote: >> Can you give an example of the field I. The main form, the field on the >> other form and what you are seeing. >> >> Also when you say mapped what do you mean? >> >> Thanks >> >> Ann >> >> Sent from my iPhone >> >> On 15 May 2012, at 11:24, vidyasagar kommu >> wrote: >> >>> 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" >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" >> > > > -- > Sagar > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: how to get the values instead of ID's in the Database table
Sagar, you can create SQL join and pull details from the menu defination if it is only for reporting needs You can also save the value in the DB what is shown to user insted of saving ID of the selected menu. check 'Value Field' and 'Label Field' in menu. you might have to chage data type of filed which is storing value from Int to Char (if it is not char) regards Ravi Rai > Date: Tue, 15 May 2012 09:12:42 -0400 > From: ago...@jcp.com > Subject: Re: how to get the values instead of ID's in the Database table > To: arslist@ARSLIST.ORG > > -- 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 > ago...@jcpenney.com > jcpenney > 6501 Legacy Drive > Plano, TX 75024 > jcp.com > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of vidyasagar kommu > Sent: Tuesday, May 15, 2012 5:24 AM > To: arslist@ARSLIST.ORG > 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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: how to get the values instead of ID's in the Database table
-- 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 ago...@jcpenney.com jcpenney 6501 Legacy Drive Plano, TX 75024 jcp.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of vidyasagar kommu Sent: Tuesday, May 15, 2012 5:24 AM To: arslist@ARSLIST.ORG 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"
Re: how to get the values instead of ID's in the Database table
Hi Ann, In the main form i have filed "A" this field A is dependent on prooduct and producttype value when the user select product and product type value so i need to pass the product and product type dynamic values to another form i.e regular form for getting the Field A value for this approach i used Search menu. Another form filed B( B filed also dependent on product and product Type) based on the user selection of A filed value it should derived B filed value. In this form i have CReated A filed and accordingly i have mapped with B filed data In this approach getting the values i am using Serach menu.in the search menu qulication i have given Database ID of the main form Filed A Id and product and product Type Id's. Thanks Sagar On 5/15/12, Ann Ctl wrote: > Can you give an example of the field I. The main form, the field on the > other form and what you are seeing. > > Also when you say mapped what do you mean? > > Thanks > > Ann > > Sent from my iPhone > > On 15 May 2012, at 11:24, vidyasagar kommu > wrote: > >> 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" > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > -- Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: how to get the values instead of ID's in the Database table
Can you give an example of the field I. The main form, the field on the other form and what you are seeing. Also when you say mapped what do you mean? Thanks Ann Sent from my iPhone On 15 May 2012, at 11:24, vidyasagar kommu wrote: > 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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
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"