Hello,
Is there a way to create a formula to look at a certain value in for example table1 and check table2 to see if it contains a defined value listed in table1? I have two multiple values table (Follow-up table and Sign-off table).

Below is an example of a record with the Follow-up table contains multiple values with 2 Consult values needing consult role to review. Only 1 of the 2 people we've consulted with has signed-off on the file. How can I create a formula to identify that the file still needs Review - Legal completed from the Sign-off table?

{Follow-up Table}        {Sign-off Table}
Consult - Legal              Manager Sign-off
Consult - ITS                 Review - ITS
Chart Review
Meeting-Patient/Family

Thank you very much for your help in advance!

Hi DBlank,

Thank you for your comment! Below is a better example of an actual record with the different follow-up types and sub-types assigned to the record. The record is marked with "Work done on file" as the follow-up type and a sub-type of "Consult - Legal". I'd like to create a formula to identify that the record is missing follow-up type of "Sign-Off" and a follow-up sub-type of "Review - Legal". Is it possible to create such formula in Crystal Reports?

FollowUp_Type          FollowUp_Sub_Type
Work done on file      Meeting
Work done on file      Chart Review
Sign-Off                   Manager Sign-Off
Work done on file      Consult - Legal
Work done on file      Consult - ITS
Sign-Off                   Review - ITS

Thank you!