I have two tables in a relationship and need to check if the value in a field in the entered in the parent table exists in a column in the child table. The use case, the parent table contains order information and the child table contains verification data for some of the order data. A ticket is created in the child table by an automation (soon to be replaced with a pipeline) when a new order is created in the parent table. However, for various reasons the individuals doing the verification may not be able to find the ticket that was created by quickbase. If they cannot find the system generated ticket, they will manually create a ticket. The best I can hope for in this situation is to check if they project manager enters a valid ticket number in the parent table. By valid I mean that the ticket number entered in the parent table is actually in the ticket field in the child table.
I hope that made sense and am looking forward to your suggestions.
your logic works fine for the instances where the verification team is able to locate the auto generated ticket. However, that is not the issue. The issue involves orders that the verification team cannot find the auto generated ticket (mainly due to missing data in the order). In those cases there a manual ticket is created and there is no connection to the order, therefore the summary field will not return any results.