topic Re: linking text table in Application Development and Automation Discussions

linking text table

Former Member — Wed, 16 Apr 2008 10:32:53 GMT

Hi all,

i have a table name Zcustom and a text table ZcustomT.

How do we link text table to the transparent table. so that when the user displays the entries of the table Zcusotm the text field should be shown in the display. as well as when he clicks menu GOTO->Text table it should automatically takes to ZcustomT.

could somebody tell how to do this linking.

Thanks in Advance.

Neha

Re: linking text table

Former Member — Wed, 16 Apr 2008 11:27:39 GMT

Hi,

Just create the text table with the same key fields and add language field as an additional.

to define a text table for a table

Define T1 with the following fields

f1 Key

f2 Key

f3 key

Define t2 with the following fieldds

f1 key

f2 key

f3 key

f4 key - This is of type language

Define foriegn key for t2 from t1 for f1, f2, f3 and while defining foriegn key, select the radio button key fieldds of a text table

This brings the table T2 when are in display / change mode of T1 and click on text table.

Regards,

Kumar(Reward if helpful).

Re: linking text table

Former Member — Wed, 16 Apr 2008 11:53:01 GMT

Hi,

This is the concept of text table. No need to link anywhere.

If you want to create any table like this.

1. take andAdd all key of the table .

2. add two fields : language and Text i.e. SPARS, TEXT

3. Make language as key field

4. Save table as transparent table.

Maintain foriegn key relationship betwen the tables with all the fields from second table.That's all.

Regards,

Raj.

Re: linking text table

Pramanan — Wed, 16 Apr 2008 12:03:48 GMT

hi,

Consider two tables z1 and z2

in z1 having fields like CARRID MEALNUMBER MEALTYPE

in z2 having fileds likeCARRID MEALNUMBER SPRACHE TEXT

z2 is text table for z1.

This is possible by the following three things.

1. For z1 carrid give check table link with z2 by selecting keyfields/candidates in Foreign key window

2. For z2 mealnumber give check table link with z1 by selecting

keyfields of text table in Foreign key window.

3. Sprache text should be in the text table (z2).

For reference use smeal and smealt tables (smealt is text table)