I have a progress note table where a person's social is entered, the
current date and then the note. I can have serveral notes entered
under the same date and I can have several notes entered on the same
social. My question, how do I lookup and display a certain note based
on the social and date of the note?
03/09/06 999-99-9999 Note
03/09/06 222-22-2222 Note
03/10/06 222-22-2222 Note
03/10/06 999-99-9999 Note
If I base the lookup on Date, it pulls the first occurence of the date.
If I base it on social, it does the same. How would I display the
note of 03/10/06 for 99-99-9999?
Thanks!