Jump to content
Sign in to follow this  
Sajjad

Searching repeated fields & displaying result

Recommended Posts

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.

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

Vaughan,

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

Cheers

Saj

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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