I have a repeating group w/ users. Repeating group is of data type = User
Two data types exist in my database:
Data Type: User
Field: Auto Auto FK
Data Type: Car
Field: license plate
Field: User User
So each User has 1 Auto.
I want to allow the user to set multiple constraints that apply to fields found in different datatypes. I have a search box to search trough the repeating group. I want to search trough the repeating group on both data types. So for example i want to search for firstname in data type User, but i also want to search for license plate in data type Car.
The problem is that i set the type of content for the repeating group to User, with the Data source as following: Do a search for Users. It has a constraint: Any Field contains input Searchbox’s value, but ofcourse it does not search for the license plate in data type Auto(because it is a other data type and not User data type). How can i also search in data type Auto?