Hi Everyone,
I'm trying to create a database for my job that will store info on scholarships in our area. Each record (scholarship) will have information on in many different fields. Some fields are text and some are lookup/combo boxes. I want our clients to be able to search for records based on some fields (combo boxes), but not others and then see their results (ideally in a split form). I have tried a few different ways, can't seem to get it to work. Either it comes up with no results or it comes up with hundreds of results (copies of one record).
Any help/feedback/suggestions would be great!
Thanks!