Skip to Content
0
Former Member
May 29, 2008 at 01:02 PM

Need to Create Search Help Based on Condtions from one table to another tab

19 Views

Hi All,

I have a table like ZGROUP Which contains the data below

Filed name Filed Name Filed Name

ZGROUP ZTYPE ZTEXT

Entries

ABC P TEXT FOR

C P SDFNSDFKLN

DDDD PSG TEPRTPERERTWERT

DEF P TEST

FFFFF PSG

SEF PS SDFSDFLASLDFNASDLFN

XYZ PS TESTING

Whree P is Product , PS- Point of Sales, PSG-Sales Group

Now i am going to crate another ZPROUDCT TABLE

FIELDNAME FIELDDESCRITPON

PRODUCT PROD_DESC

Entry

abc pRELATED ENTRY

My Questions

1) ZGROUPS table has 3 kinds of data P, PSG, PS type records,

1) In Table ZPROUDCT , I want to create search help only P records for Table Zproduct of the field Product FROM zGROUPS table

2) In Table Zsales , I want to create search help only PS records from ZGROUPS table

3) In Table ZPSG, I want to create search help only PSG records from table ZGROUPS

is it possible to create search help from One Master Table(ZGROUPS) table to other tables based on conditions.

Please help me.

very urgent

Regards,

Raju