Nicholson, Karen
cyx5 at cdc.gov
Fri Aug 19 12:13:10 CDT 2005
In my case, I have part numbers that are stored in over 1000 different tables. Management wants to find a part number. It is not (yet) in a central location, but I am working on it. To find a part number, the person would have to know the manufacturer before they can find the part number. Management does not know that. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Friday, August 19, 2005 11:48 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] "Find" combo box searches more than one table I never understood what the user expected to "find" in such a search function. Did they want to know every table the value appeared in, did they want to magically "see" each record in some form? Are they expected a treeview showing all the hits in each record in each table? It isn't hard to find a value by walking the tables, but what did you want to do with the results? Charlotte Foust -----Original Message----- From: Klos, Susan [mailto:Susan.Klos at fldoe.org] Sent: Friday, August 19, 2005 8:27 AM To: accessd at databaseadvisors.com Subject: [AccessD] "Find" combo box searches more than one table Yes, Kath, I think that is what I am looking for. Can you send me a copy of the code? Susan Klos Senior Database Analyst Evaluation and Reporting Florida Department of Education 850-245-0708 sc 205-0708 Maybe Susan means that the users would like to have a 'search function' which will find something anywhere in the database. I have had that request before, eg. for a database that tracked travel agent wholesalers, travel agent retailers, suppliers, clients etc. Users would get an inquiry from someone and wanted to type in their name and find all instances anywhere in the system. It depends whether you need to populate a combo or not. In my case I created an unbound text box and users type in any part of the person's surname and hit enter. The code then searches through the relevant tables one by one and populates a results table. Kath -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com