AnsweredAssumed Answered

Searching Multiple Values through one field?

Question asked by ChristofferRexen_1 on Oct 31, 2017
Latest reply on Nov 7, 2017 by ChristofferRexen_1

So, I know this question pops up a lot, but I still can't seem to find my answer in the haystack.

 

I am building a Self Storage database for a customer.

Now, when the employees of the Self Storage database gets a customer, I would like them to enter a desired number interval, say 3-5, to list all vacant storage rooms with 3-5 square feet of space for rental.

Although when I try this, I don't get the desired result, actually I don't get any result at all.

- Please see attached images.

 

I even tried altering the relationship like written below, since I would assume this would list all possible storage rooms, but with no luck:

CUS_ListUnits__gxn ≥ UnitSquareMeters

CUS_ListUnits__gxn ≤ UnitSquareMeters

 

Help is needed and much appreciated.

/ Christoffer

Outcomes