Hi
I recently posted another message relating to subforms in my library catalogue. This problem is that I have an interface to the catalogue to enable searching for information in several fields. The main form has a subform linking to a table titled Subject Keyword. When I catalogue an item I can select multiple keywords. However when I've conducted a search using the menu interface and using two separate keywords, no results are returned. I checked that I the combination existed first. Could it be because I can't retrieve data from the same table twice?
Sorry I am probably not explaining myself very well.
I recently posted another message relating to subforms in my library catalogue. This problem is that I have an interface to the catalogue to enable searching for information in several fields. The main form has a subform linking to a table titled Subject Keyword. When I catalogue an item I can select multiple keywords. However when I've conducted a search using the menu interface and using two separate keywords, no results are returned. I checked that I the combination existed first. Could it be because I can't retrieve data from the same table twice?
Sorry I am probably not explaining myself very well.