Jump to content

Searching repeated fields & displaying result


Sajjad
 Share

This topic is 7438 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 2 weeks later...

This topic is 7438 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.