Question about an automatic lookup field

  • Thread starter Thread starter jag
  • Start date Start date
J

jag

I have an address table which has the ServID, ServiceAddress, and WOrder ID.
The second table is the Work Order table, which consists of other detailed
work information

I first want to open a form which is used to choose the service address. I
assumed I would have to use a combo list box to be able to look up the
address. If possible, is there a way to just begin entering the service
address in the field without changing information relating to the ServID.
When I attempt to enter the address, it changes the information instead of
looking up the information. I don't want this information changed, only
want it to be easily looked up then related to the work order subform., and
it would automatically go to the match and add the link to the Work Order
Subform.
 
Does each ServiceAddress have just 1 WOrderID assocaited with it or it is
possible to have multiple WOrderID for a ServiceAddress? If you have
multiple WOrderID then a search will bring up the first record showing the
first WOrderID only. Would an option to filter out only the address chosen
be OK? That way after you choose an address, you could use the record
selection arrows to move to other WOrderIDs. If you have to be able to move
to any record at all times then you will need to change your design of
choosing an address to include choosing a WOrderID as well. I can tell you
how to perform the above mentioned functions but I need to know more about
your data.

Kelvin Lu
 
Back
Top