Search Several Tables

J

JIM

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top