topic text table for a table in Application Development and Automation Discussions

text table for a table

Former Member — Sat, 02 Feb 2008 06:20:14 GMT

Hi,

How to create text table for a table

Thanks,

Das.

Former Member — Sat, 02 Feb 2008 06:27:00 GMT

In general the text table's name will be "T" attached as the last character for the actual table name...

Check CAWN table ... The text table for this is CAWNT

This Text table contains the Key same as the main table with an Extra field Language as key...

The contents of this table are the texts for the field values....

Former Member — Sat, 02 Feb 2008 09:18:52 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.

Reward Points if found helpfull..

Cheers,

Chandra Sekhar.