A better way to construct "Set User Selection" for this?
Here are my fields
Car, Brand, Color, Units
Here's my data. I have max of 6 records at a time
- Honda, Civic, White, 1
- Honda, Civic, Black, 2
- Honda, Civic, Silver, 3
- Honda, Civic, Green, 4
- Honda, Civic, Blue, 5
- Honda, Civic, Gray, 6
As you can see, Car and Model fields are the same. The only differences are Color and Units. I'm planning to have 4 "Set User Selection" statements for each record (24 total). I don't know if there's a limit to number of conditions in data selection or not. For example
Car Equal Honda And
Brand Equal Civic And
Color Equal White And
Units Equal 1 OR