Hi, I have a query that has 2 query fields. Users can either enter an ID or a Name and it pulls back the appropriate fields. Since a user might want to search by name for some entries and ID for other in the same project, I want the ID to clear if they enter a value in Name and vice versa. I do have custom code for the query in C#.
Any suggestions?
Thanks.