Searching for a list of things by foreing key

[lgarcialuzzi]

Hi! I have a table of events with different states. The event state is a foreing key from the table “eventStates” and I match them by there eventStateID, wich is a number value.
I want to create a list of events with specific states, so i created a Repeating group of events, but i’m having trouble to indicate the constraint “eventState = Some number”

wich option should i use to indicate a number to match the eventStateID?
The documentation I found specifies in text constraints, but it wasn’t helpful.
Thanks!

[tylerboodman]

That state field, is it the datatype eventStates?

If so sounds like you want to do Do a search for eventStates with the constraint eventStateID = [type the one you want] then do :first item after the search.

[lgarcialuzzi]

This worked perfect! Thank you so much!!