Searching repeated fields & displaying result

[Sajjad]

This is probably a 'stupid beginners' question, but here goes...

I have a database with a text Description field that is repeated 6 times. Each description line represents a seperate item of data in that record.

When I perform a search on this field, using the preview mode of a columar list/report, I get all the correct records but only the top line of the repeated field.

e.g. If the data I want to find is in line 3, I want FM to return that line and not all/any of the others.

Is this possible, as I really don't want to have just one data line per record.

[Vaughan]

This is a limitation of repeating fields, and the main reason why they should not be used. Instead, use a relationship and portal, then perform the find in the related file.

It might be hard at first, but doing it the propper way is actually easier in the long run.

[Sajjad]

Vaughan,

Finally cracked it! Thank you for pointing me in the ight direction.

Cheers

Saj