In myÃ, requirement 2 fields refer to same Columns (shortname) in database table .
can any tell me how to map same column to different fields?
Mapping for field is
Services --> program --> category(shortname)Ã, : Activity
Services --> program --> category(shortname)Ã, : Sub activity
Create alias for program and category tables and join alias program table to program and Alias category to alias table of program table
or you can do it by creating shortcut for programs and category.
i am not clear with ur problem. Is that u want to join the different tables with same column, or u want to rename the same columns with two names..
If i am correct i feel you wanna rename the same columns with two names. then edit the sql of the table and then
add services.program.category as sub activity in the select clause.
Plz clarify
Srik
thanks srik for your info.
I got the logic .
Thank you,
Kanth
share the logic and update the topic..
Srik
Quote from: kanth on 27 Apr 2006 10:19:44 PM
thanks srik for your info.
I got the logic .
Thank you,
Kanth
k