Is there a way to have the searchbox search through different Database Types and Fields?
- I have 2 database types: Dogs and Cats
- Within those types, I have these fields:
- Dogs: Field 1 is Color, Field 2 is Breed
- Cats: Field 1 is Name, Field 2 is Gender
Now, let’s say I have a cat named White, and the color of one of the dogs is also White.
I need the searchbox to display the following when entering “white”:
White, Cat, Male
Rex, Dog, White