I'm developing a solution with a one-record viewer file. There is a twenty-six-record file called Service.fp5 which lists 26 different categories, with serial numbers 1 through 26. These services need to be field labels in the viewer file.

Is there any way that I can do this without setting up 26 different relationships? I tried calc fields of GetRepetition(Service__constant1::serviceName, 1) all the way up to 26, but that only works on repeating fields, not related fields.

The client wants a static multi-columned table to be shown at the bottom of several layouts, that uses these labels, so I can't do it in a related file or a portal. I would really like to have the labels dynamic because the clients are known to change their mind frequently about semantics; they need to be able to change the labels themselves.

Any ideas? Thanks.

Paul

How would a single field with 26 check boxes work?

That won't work, unfortunately. They need the ability to type over the names of any of these services (e.g. to change "Consulting" to "Professional services", when they decide that that would "sound better" even though it's the same service), and there are also other fields in each record for the service, that we will need to reference. The table will always show all 26 services.

Thanks, Vaughan.

Paul

Never mind everyone. I figured it out.

I parsed ValueListItems() into 26 globals.

Thanks,

Paul