topic Re: Display values from check table in Application Development and Automation Discussions

Display values from check table

Former Member — Thu, 26 Mar 2009 17:52:35 GMT

If there is field in table A, I want to put check table for this fields, saying the check table is table B.

When I input value for the fields of table A, not only I would like to display restricted value for the related field from table B, but also another field in table B, saying u201Cdescription" field.

How to achieve this ?

Thanks

Liang

Re: Display values from check table

Former Member — Thu, 26 Mar 2009 18:04:11 GMT

Is table B a text table for table A?

Rob

Re: Display values from check table

Former Member — Thu, 26 Mar 2009 18:05:10 GMT

Yes. I need to define a search help, right ?

Thanks

Liang

Re: Display values from check table

Former Member — Thu, 26 Mar 2009 18:11:43 GMT

Well, I'm not sure exactly what you are trying to do.

Rob

Re: Display values from check table

Former Member — Thu, 26 Mar 2009 18:16:41 GMT

Hi, Rob:

My table A has a field saying "ID", the value of the fields should be restricted by the values of "ID" field of table B, so I put table B as a check table for "ID" field of table A.

When I input value for "ID" field of table A, I have a list of the restricted values of "ID" which from table B.

Because ID value does not have bususiness meaning, I would like also want to have "Description" field desplayed as searh help.

Is this clear ?

Thanks a lot.

Liang

Re: Display values from check table

Former Member — Thu, 26 Mar 2009 18:18:46 GMT

So you're only interested in seeing the description in a new search help that you are building?

Rob

Re: Display values from check table

Former Member — Thu, 26 Mar 2009 18:23:15 GMT

I am interested in seeing both values "ID" and "Description"

Liang

Re: Display values from check table

Former Member — Thu, 26 Mar 2009 18:36:19 GMT

I guess you can start by creating a search help with table B as the selection method.

Rob

Re: Display values from check table

Former Member — Fri, 27 Mar 2009 11:29:46 GMT

Hi,

I think there is no need to create the search help,

If any how you can make the description field also a key field.

So that the primary key in table B consists of another field description.

So the primary key in table B = mandt + id + description.

Re: Display values from check table

Former Member — Fri, 27 Mar 2009 15:14:25 GMT

I think I got the idea to do it.