adding automatic data to form field

[magicrob]

Hi all

I'm trying to add a field on a form which is composed of three parts, which I'd like to automate:

XXX/YYY/ZZZ

XXX: One word which stays the same

YYY: A code which is unique to each client (one client can have many forms)

ZZZ: A code which is unique to each briefing form

Ideally I'd like the ZZZ part to match the form ID.


I've tried using the expression builder, but have had no joy so far.


Any help much appreciated!

Thanks

 

[Galaxiom]

I would store YYY and ZZZ in different fields as they have an important meaning within themselves.

Concatenate the fields, slashes and the fixed string for display.

= "XXX\" & [YYY] & "\" & [ZZZ]

XXX stays the same for all records so you don't store it at all.