Hi, I'm trying to understand best way to approach a search. I would like to use the Alpha search on lebans site-is it the best choice?
I want to create a work order with three tables, customer, contacts, and buildings. I would like user to click on an alpha character to bring up all customers starting with that alpha character(into a combo box, I think) then be able to click on desired customer to bring up all of that customer's buildings and populate the main form then be able to click on a building to populate a subform thus creating each work order. The customer table is one to many to both contacts and buildings. Any help appreciated. JIM
|
|