2 Replies Latest reply on Mar 20, 2012 1:16 PM by shashikanthkuntla

    Using 'OR' operator for a two different fields

    shashikanthkuntla

      Title

      Using 'OR' operator for a two different fields

      Post

      Hi All,

      Is there any way to find records using "or" operator between two different fields in the table of FileMaker Pro.

      I have around 51 fields in a table, I have four fields as flags (a,b,c,d). I wanted to display only those records when either flag a is set or flag b is set to 1.

      Its something like:

      If either flag  a or flag b is set to 1, then it should dsiplay the record. When i search using this criteria there shouldn't be any duplicate records. for Eg: If both flag a or flag b is set to 1 then that particular record should display only once.

      Please let me know in case you require any additional information.