Results 1 to 6 of 6

Thread: Confused! Table Design

Threaded View

  1. Nov 5th, 2004, 11:43 PM #1
    kdlc
    kdlc is offline

    Thread Starter
    New Member
    Join Date
    Apr 2004
    Location
    Inside my Computer ...
    Posts
    2

    Question Confused! Table Design

    I have a Table called CERTIFICATES:
    * CertificateID
    * StudentID
    * CertificateNumber
    * DateIssued

    THE PROBLEM:
    In some cases the customer may ask for another certificate because he lost the first one ... but the tricky part is that my client will issue a new certificate (not a copy) and he wants to know which certificate is being “duplicate”.

    EXAMPLE:

    * Fist Certificate:
    Certificate ID: 1
    StudentID: 100
    Certificate Number: AA123456
    Date Issued: 10/02/2004

    * New Certificate:
    Certificate ID: 20
    StudentID: 100
    Certificate Number: AA123499
    Date Issued: 11/02/2004
    Duplicate (Certificate ID): 1

    So … I would like to know which would be the best way to do this … any suggestions??


    Thanks in advance
    Last edited by kdlc; Nov 6th, 2004 at 03:29 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width