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.