# Getting results searching multiple fields

**URL:** <https://forums.knack.com/t/getting-results-searching-multiple-fields/7573>\
**Category:** Get Answers\
**Created:** [August 18, 2016, 11:12pm UTC](https://forums.knack.com/t/getting-results-searching-multiple-fields/7573 "2016-08-18T23:12:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![TrevorZimm88572](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@TrevorZimm88572](https://forums.knack.com/u/TrevorZimm88572)\
**Post date:** [August 18, 2016, 11:12pm UTC](https://forums.knack.com/t/getting-results-searching-multiple-fields/7573/1 "2016-08-18T23:12:32Z")

</div>

I am doing a film database.  
  
I have one object named films. And I have one object named directors.  
  
Films has 4 fields for director (Director 1, Director 2, etc).   
  
Each field (Director 1, Director 2, etc) is connected to the directors object (with only unique values populated).  
  
How do I display one table of all the films which feature the director.  
  
When added a new page selecting the director's object, I can make a search which show four separate searches for Director 1, Director 2, Director 3 field. But this is very ugly and I'm unsure is not the right way to do this.  
  
For example say the movie FAKE MOVIE, was directed by (Director 1: George Lucas, Director 2: Bob Saget, Director 3: Stephen Speilberg, Director 4: Null). The search result for Stephen Speilberg looks like

Films  
Film title: No Data  
  
Films:   
Film title: No Data  
  
Films:   
Film title: FAKE MOVIE  
  
Fiilms:  
Film title: No data  
  
I can't figure it out. Any help would be greatly appreciated.
