Joining fields / concatenating

Joining fields / concatenating

Hi - I have a Product Master form and a Products form.

A Product Master can have more then 1 Product - so a Master could be "brown wrapping paper" with a Code of "BWP" and the Product could be "900mm wide" with a Code of "900MM".

So I want to allow the user to select a Product Master from a look up list - I know how to do this - and then enter the Code "900MM" and have the Product show the result as "BWP-900MM"

I have looked through the help and can't see how to concatenate / join those 2 fields...

It is probably simple...

Thank you

        Zoho Pagesense Resources

          Zoho SalesIQ Resources



                Zoho TeamInbox Resources

                  Zoho DataPrep Resources



                    Zoho CRM Plus Resources

                      Zoho Books Resources


                        Zoho Subscriptions Resources

                          Zoho Desk Resources

                            Zoho Projects Resources


                              Zoho Sprints Resources


                                Qntrl Resources


                                  Zoho Creator Resources


                                    Zoho WorkDrive Resources




                                        Zoho Campaigns Resources

                                          Zoho CRM Resources

                                                  Design. Discuss. Deliver.

                                                  Create visually engaging stories with Zoho Show.

                                                  Get Started Now


                                                    Zoho Show Resources