Quote:
Originally Posted by Sabardeyn
eschwartz,
Could you please clarify how entering either series name in a search would return the other series?
For example, we have a series called The Red Series and another series called The Orange Series. We have one book (Red Meets Orange) that fits into both series. In The Red Series, this is the first book. In The Orange Series, this is book thirteen.
What database structure/fields are needed? What search is used?
I'm wondering if I'm overlooking some simpler means to handle such cases.
|
The searching solution is described in post #9. It assumes that you have multiple series columns (the normal + N custom) and that the grouped search term contains all the columns.