Lookup table

[Charles Evans]

I am using v8.03 advanced and I have two fp7 files. The first one is the main one and the second one I am using as the lookup file. I have

set the relationship and that works fine. How do

you get filemaker to get all occurences of the match out of the lookup file? Ex:

Mainfile.. 100 name address city state

Lookup file.. 100 dollarone dollartwo

100 birthdate marrieddate.

When mainfile addresses a record with field 1 = 100, filemaker sees the first record match in the lookup file but I need it to continue through the

file to find the next occurence. I hope I explained this ok. Thanks in advance for the help.