Autolookup queries

  • Thread starter Thread starter Brad@Zelle
  • Start date Start date
B

Brad@Zelle

Please help. I am trying to creat an autolookup fields.
I have 2 tbls a Calls tbl and Callers tbl. I want to be
able to select a callers name from a drop down field, in
the calls form and would like the callers office, phone
number, and extention to auto fill in the Calls from. I
am having trouble wrapping my thoughts around this. Can
anyone help me design this.
 
Ken, so far so good. Thank you. Now for the next step. I
need the autolookup fields to refresh when I mover to a
new record. Also how do I get the autolookup values to be
stored in my main table so that they are related?

Thanks again
 
Not sure I'm following... your first post said the "refresh" should occur
when the user makes a selection from a combo box. What happens when the user
goes to a new record that is different? I'm also not sure about storing the
values in a main table (or at least what you want to do here)?

Please elaborate with more info about your setup and operations.
 
Back
Top