AnsweredAssumed Answered

Concatenate Lookup

Question asked by EricWang on Aug 22, 2014
Latest reply on Aug 22, 2014 by philmodjunk


Concatenate Lookup



     I am fairly new to filemaker pro so please excuse my ignorance on the matter. I'm making a mouse colony database and I was wondering how to concatenate a lookup.

     I have a table (Mouse Records), with the fields Allele 1, Allele 2, Allele 3, Allele 4. 

     I have another table (Breeding Records) with the field "Genotype".  

     I want to set up a lookup where I enter the Animal ID in the breeding records , and it takes information from the Mouse Records from Allele 1, Allele 2, Allele 3, Allele 4, and concatenates them into the Genotype field in the breeding records table.