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.