Using 'OR' operator for a two different fields
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.