Jump to content
  • 0

Hiding Duplicate Records with Same Field Value


Scribblescraw
 Share

Question

Hello!

I have a search and report page in which users can search based on multiple non-mutually-exclusive attributes. After selecting the attributes they want to search for, the report then pulls up records that correspond to any of those attributes. The results page is very simple-- it uses the ID for the record to display, and then there is a link that passes to a more elaborate details page that essentially just shows all of the information for that record, sort of like a card. However, because each attribute has a separate record that links to the same ID, it can show multiple results with the same ID. 

I want to write a script or something that will make it so that if there are multiple records with the same field value (the ID), it will only display one (by combining all of the records into one line or by hiding the others). Is this possible? 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hi,

You have two options at this stage.

  1. If you have multiple records that share the same ID, then you need to reestructure your table as there must be a one to many relationship between them. Once you do that, you base your report in the unique records table. 
    Please review the following articles to make sure you understand table relationships and its importance:
    * Relationships
    Relationship settings
    * Managing relationships
  2. If you are not keen of getting your database properly configured as described in step one, then you can use Group option in the report datapage. This article will guide you through the steps.

Regards.

Link to comment
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
Answer this question...

×   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.

Loading...
 Share

×
×
  • Create New...