I have a double search formula ( Name & Format)
let me := this; let myArray := (select Albums); if Search_1 then myArray := myArray[Name = me.Search_1] end; if Search_2 then myArray := myArray[Format = me.Search_2] end; myArray
But the problem is with Format (is a N:1 Relation from Albums)
The Format is CD, Cd'2, Cd'3, MP3 etc
Since Format is a relationship field. Data from that field will be returned in an array. You can use the contains() command to do searches in an array. If Search_2 returns record Id from the Format table, then it would look something like:
Try changing Line 7 to this
myArray := myArray[contains(Format,me.Search_2)]
What is the type of the me.Seach_2 field?
What is the type of the Albums.Format field?
- Status Answered
- 3 mths agoLast active