Hi,
I'm running 4.1(Build 225). The database consists of 3 tables. A main data table & 2 lookup tables. I've used the lookup wizard to hook up the combo boxes on the screen just fine to the look up tables. My problem is that when the regular search feature is used it doesn't return the correct results. If I search for any column that was assigned by the lookup wizard then the search returns no results. If I use the advancedsearch then the results come back just fine nomatter which field I select to search on. The only field that the basic search works correctly on is the one field that is not linked to a lookup field. Can anyone help me out with this?
Thanks,
Corinne
