Here are the details:
The dept. I'm working with processes claims (data stored in table {CLAIMS}). All open claims should have an open diary attached to them (stored in table {FILEFOLD}). The FILEFOLD table allows and stores different types of entries; D for Diary, L for Letter, N for Note, F for Form. I have the report laid out; my problem is finding the claims that lack an open diary without returning all of the other codes as well (e.g., if I select claims where FF_TYP<>"D", of course, I'll get all of the other FILEFOLD types). If I say FF_TYP="D" and FF_STATUS<>"O" (Open), it won't return claims where there never was a diary.
Hope I've explained this clearly enough; if not, I'll be happy to provide any information you gurus may need. :0)
Thanks.
Kyle
The dept. I'm working with processes claims (data stored in table {CLAIMS}). All open claims should have an open diary attached to them (stored in table {FILEFOLD}). The FILEFOLD table allows and stores different types of entries; D for Diary, L for Letter, N for Note, F for Form. I have the report laid out; my problem is finding the claims that lack an open diary without returning all of the other codes as well (e.g., if I select claims where FF_TYP<>"D", of course, I'll get all of the other FILEFOLD types). If I say FF_TYP="D" and FF_STATUS<>"O" (Open), it won't return claims where there never was a diary.
Hope I've explained this clearly enough; if not, I'll be happy to provide any information you gurus may need. :0)
Thanks.
Kyle