AnsweredAssumed Answered

Using 'OR' operator for a two different fields

Question asked by shashikanthkuntla on Mar 20, 2012
Latest reply on Mar 20, 2012 by 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.

Outcomes