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