how to show the field with name and id?

[daisy1438]

Hi

I have two fields Product_Name and Product_ID

DATA:

Product_ID,Product_Name

101,car

102,van

I fornt end filter pame user want product name along with product id

Neecloumn:
car(101)

van(102)

like that i need to create aa filed.How to do this?

Thanks

Daisy 

[stevejoyce · Accepted solution]

Product_Name & '(' & Product_ID) & ')' as Product_Name_ID