Troubles With One to Many Relationships....

[Dr Kyle]

First off, I am new to this board and want to say "hello"!

I have attached a .jpg pic of my current FM7 file. You will see Ten TEXT fields (highlighted in blue) which all contain the scientific names of genes in the Fruit Fly Genome. What I am trying to do is relate each one of these Ten fields back to the SAME FIELD OF ANOTHER FM7 FILE to lookup whether each gene name appears in the other file... and then to report the record number it appears in in the file. You can see me trying to test this out using the two sample fields "Peptide1_Rec#_In_Unannotated_List" and "Peptide2_Rec#_In_Unannotated_List". However, when I link anything more than one of the "Protein1, 2, 3, etc" fields to the same field in the second file, the Record number lookups either stop working altogether or lookup the same data for all cases (as seen in the current photo). This record number (in the photo) is right for Protein1, but Protein2 is just reporting the same as Protein1 is instead of reporting its own. If I make a relationship for Protein3 to the same field in the other file, they all stop working.

Am I breaking some kind of rule here? I tried to just make ten "copy" fields in the file I am linking them all to, so each of the "Protein" fields would have its own relationship with a "clone-field" of the original one... But in this case I couldnt figure out an easy way to get the data in the original field to be "copied" into the other ten for all 223 records.

I really need some help guys...

KYLE

[RalphL]

When you have more than one field for the same type of thing it is time to go to a related table and use a portal to view these items. 10 Proteins should therefore be relplaced with a related table Protein.

[Dr Kyle]

Thanx... I got it working now!

KYLE