August 27, 200619 yr Hello Can filemaker 8.5 do this I wonder? I have a database with a layout with some drop down menus. One of these is Grade and includes: GP Principal/Partner GP Private GP Registrar GP Retainer GP Returner GP Appraiser All of these people are GPs but they're all slightly different. What I'd like to be able to do is search for all GPs. The only way I can think of doing that at the moment is to go into the find mode, choose GP Principal/Partner, create a new request, choose GP Private, and so on down the list. Another way would be to display the Grade field as a check-box field in the find mode. So the field displays as a menu in the browse layout and a check-box field in the find mode. I can't see any way of doing this but is there? Thanks Nicole
August 27, 200619 yr If you are searching for GP then it strikes me that it might need it's own field. Might there also be other examples of the same problem ie Staff Nurse, Trainee nurse, consultant nurse etc? in which case it might be better to have 2 fields - Position and then grade Phil
August 27, 200619 yr Author Well the GP thing was only an example. I was wondering if it needed separate fields but then we'd have to do that for every field. And guess what people might want to search for. Tricky. I had hoped there'd be a more elegant solution. Hmmm.....will have to ponder.
Create an account or sign in to comment