On fields which are foreign keys and for which it is specified that the relation should use a dropdown, the default value for the search option should be 'exact match' instead of 'like'.
Let me give an example using the famous book / author relation. You want to search for books that are written by author 'Jasper', which has id 2. In the books search form, you get a drop down list with author names (and the default search option is 'like'). If you would select 'Jasper' from the drop down list, you will get all books by Jasper, but also all books by other authors which have the number '2' in the AuthorId. This is quite an unexpected result.
Could this be fixed in DBMan SQL?
Thanks, Jasper
http://www.bookings.org
Let me give an example using the famous book / author relation. You want to search for books that are written by author 'Jasper', which has id 2. In the books search form, you get a drop down list with author names (and the default search option is 'like'). If you would select 'Jasper' from the drop down list, you will get all books by Jasper, but also all books by other authors which have the number '2' in the AuthorId. This is quite an unexpected result.
Could this be fixed in DBMan SQL?
Thanks, Jasper
http://www.bookings.org