I have an issue I am hoping to find a solution or reason to or for.
To make it very simple, or to attempt to, I will use the metaphor of a Book Recommendation App.
It includes two main forms: ReadersForm (perspective readers) and BooksForm (book collection).
Each includes 3 (related) Multi-Select Lookups: Genre, Author and Subject.
I have a deluge script that adds to a list each book that matches each of the Readers choices in the lookups. Such as Genres: Sci-Fi, Authors: Dean Koontz etc. This script needs to add a book to the list regardless if it is on the list already. Ie: It adds the Book “Firefly” twice to the list. Once for Author matching and once for Genre matching, so that a Count (non distinct) can be calculated as to which book hits the criteria the most for this reader, in this case should be a count of 2 and if all other books only matched 1x, then this book would be the highest recommended book to the reader...
Everything works fine on my end, except the fact that the list won’t add the same book twice to the list, so the count cannot be correctly calculated. Is this a limitation I am running into, or is this on my end, I guess is my primary question.