Displaying values of a field in 2 columns
Posted on 2011-10-25
I have a table field which holds two types of values.
There is another field called type_cd which tells us what type it is, like member (type_cd = 1), guest (type-cd = 2). Member & guest names come from another table.
Here is how the fields look in the table
When I display the member and guest names (for a company) in two columns, they are being displayed like this:
company_id Member_guest_id Member_name Guest_name
123 3434 David Miller
123 9565 Chris Valer
123 6332 Lila Woods
123 9778 Paul Works
What should I do if I want to avoid the spaces in Member_name & guest_names ?
I want the result to be as follows:
company_id Member_name Guest_name
123 David Miller Chris Valer
123 Paul Works Lila Woods
(I don' t need to display the Member_guest_id )
Thanks for your help!