Group:  Microsoft Access ยป microsoft.public.access.formscoding
Thread: Search Several Tables

Geek News

Search Several Tables
JIM 11/12/2008 4:48:02 AM
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

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net