Duplicate Fields

Results 1 to 2 of 2

Thread: Duplicate Fields

  1. #1
    Join Date
    Dec 1969

    Default Duplicate Fields

    Hello, <BR><BR>I have 2 fields that are indexed, (NUMBER & LETTER) that is, both are the primary key and based on the 2, no duplicates are allowed. However, the individual fields have duplicates. Say there are 5 records with "10" in the NUMBER field. I&#039;m displaying everything on an html page...what I&#039;d like to do is display only one of the records with "10" in the NUMBER field based on something in the LETTER field. Any advice on how to go about this will be greatly appreciated. Thanks!

  2. #2
    Join Date
    Dec 1969

    Default AspFaqs.com, Databases, General.

    See the FAQ on grouping categories and subcategories in them.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts