Forum Discussion

shanebo3239's avatar
shanebo3239
Icon for Helper I rankHelper I
9 years ago

Joining tables based on two different fields

I have an organization that has two systems, one is a lobby management system that gives out tickets (kind of like a "take a number" system).  The second system is a customer survey feedback system. ...
Need Help
BetterCallFrank's avatar
BetterCallFrank
Icon for Resolver IV rankResolver IV
9 years ago

something along the lines of

FILTER(
  LMS,
  CSF[DateSubmitted] >= LMS[StartDate] && 
  CSF[DateSubmitted] <= LMS[EndDate] &&
  CSF[LocationID] = LMS[LocationID] 
)

 shoud work for you :)

 

If you need more please post some screenshots of your data and relationships

 

HTH,

Frank