2 Replies Latest reply on Jul 27, 2012 7:57 AM by Tauryn

    One field to hold all info in other fields

    Tauryn

      Title

      One field to hold all info in other fields

      Post

      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.

      Help

      Tauryn