How to create view with two code-descriptions from the same table

[Former Member]

Hi.

I have a table with 2 different code fields: city_from_code and city_to_code.

those 2 fields has the same check table - T5J63 which contains the city codes and the city names (code descriptions).

I want to create a view which base on my table and also on the table of those code descriptions (T5J63)

in order to display in the view the 2 codes but each code with his description.

when I create the view, it is not possible to choose twice the same description table (T5J63) in the relationships (once with join to city from and once with

join to city to).

how can I display in the view, the two descriptions?

thanks

[Former Member]

Hi Ami,

Create two different view then join these two view .

Example :  1st  ABC table  + T5J63  Table  = > View 1  join to city from

                        2nd ABC table     + T5J63  Table  = > View 2   join to city to

Regard's

Smruti