AnsweredAssumed Answered

Help with creating a field

Question asked by fmpro_novice on Jul 22, 2013
Latest reply on Jul 24, 2013 by philmodjunk


Help with creating a field


     I could have 40 records in a particular database. Each of those records would have a name field and a number field. It is possible that a record's number field could be totally unique, for instance, it could have only a "1" in it's field. But it is also possible that 2, 3, 4 or more records could have the number field contain the number "1". The number field could also be a number and a letter ( 1A ).  I need another field, then, that would consider the number fields of the individual records, and if they are the same, combine those records (names) into one name field.

     In other words, if:

     Record1 =  (Name) John      (Number) = 1
     Record 2 = (Name) Jeff         (Number) = 1
     Record 3 = (Name) James   (Number) = 1
     Record 4 = (Name) Fred       (Number) = 1     then, there would be a field that combined the names John, Jeff, James, Fred.

     Record 5 =  (Name) Jack      (Number) = 2     then, the field would have only the name Jack in it.

     Record 6 = (Name) Harold   (Number) = 2A
     Record 7 = (Name) Jason    (Number) = 2A 
     Record 8 = (Name) Taylor    (Number) = 2A
     Record 9 = (Name) Chris     (Number) = 2A   then, there would be a field that combined the names Harold, Jason, Taylor, Chris

     If someone could help me figure this out, I would appreciate it.