How to add "Data Values" in a listbox??

[rabbani_sk]

For Ex. i hav a field named "Product Code",

Product Code

  A

B

  C

D

E

User wants like this

Product Code

A+B

  C

  D

  E   So , My Question is how to add the data values in a field. Any Idea?

[swuehl · Accepted solution]

Use a field expression in your listbox, select <expression> from the field drop down list on general tab (don't mix up with expression on expression tab!)

=if(match([Product Code],'A','B'), 'A+B', [Product Code] )

[rabbani_sk]

Hi Swuehl ,

Thanks for Reply..