Results 1 to 2 of 2

Thread: Search option

  1. #1
    Join Date
    Jan 2007
    Posts
    47

    Unanswered: Search option

    I have an audit database with one main table which has composite primary key(SSN, Appseq, audittype). The audits are entered in the database through entry form. I have a search option based on the SSN and Appseq so that the audits can be edited through edit form. This has no issue as
    there exisits only one record with SSN and Appseq as both of them form PK.
    I want to have one more search option with only SSN. One SSN can have multiple Appseq's. Can anyone suggest me how can I code for this search option.

    Attached is the screenshot of search option.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Is this anything like what you want?
    Not entirely sure what's being asked here...
    George
    Home | Blog

Posting Permissions

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