One field to hold all info in other fields
I am sure this isn't probably the best way to do this but here is what I am doing and need.
I am using file-maker pro 12
I have an archives database I am building for a co-worker that knows little to nothing about databases. I have about 25 fields or so and I would like 1 field they can click on and search for anything that might be in any of the other fields/records. Like a meta-tag for fields.
I set up a calculation field to handle this but is there an easier way to go about this? I am running into major calculation lengths because having to put spaces between each field. eg <field:xyx>&" "&... so forth and so on to make it work.