Lookup List Needed

In my form I have a field called DistributorName and a field called
Technician. Each Distributor has multiple technicians. I want to have a
drop down list of the technicians specific to the Distributor to fill in
after the Distributor Name is choosen. We are using Access 2006. For
example.

FRM_CallLog has a DistributorName Field(object) and then it has a Technician
Field (Object). The Distributor name field is a list of current Distributors
and the person logging a call would choose a Distributor on the list to
populate the Distributor Name field. then based on the Distributor Name that
was choosen the Technician Field would create a list of active technicians
for that DistributorName and the person logging the call would choose the
name of the Technician that they talked to. How can I accomplish this? I
tried DLookup but that does not work and doesn't give the option to pick one
name from the list. Any help would be greatly appreciated.

Thanks,

Both controls (DistributorName and Technician) should be combo boxes whose
data source is a query). The DistributorName query should be something like
'SELECT distributor FROM tblDistributors ORDER by distrinutor'. The
Technician query should be something like 'SELECT technician FROM
tblTechnicians WHERE distibutor = [Forms]![MyForm]![MyDistributorControl]
ORDER by technician'. You will need a distributor table and a technician
table and the technician table needs to contain the distributor as a column.
Needless to say, this is a vastly simplified explanation. You need the
tables and relationships set up to suport this.

-Dorian

"Leslie" wrote:

In my form I have a field called DistributorName and a field called
Technician. Each Distributor has multiple technicians. I want to have a
drop down list of the technicians specific to the Distributor to fill in
after the Distributor Name is choosen. We are using Access 2006. For
example.

FRM_CallLog has a DistributorName Field(object) and then it has a Technician
Field (Object). The Distributor name field is a list of current Distributors
and the person logging a call would choose a Distributor on the list to
populate the Distributor Name field. then based on the Distributor Name that
was choosen the Technician Field would create a list of active technicians
for that DistributorName and the person logging the call would choose the
name of the Technician that they talked to. How can I accomplish this? I
tried DLookup but that does not work and doesn't give the option to pick one
name from the list. Any help would be greatly appreciated.

Thanks,

Thanks, I will try this. I already have a Distributor table and a
Technician Table and they are linked by the Distributor ID field.



"mscertified" wrote:

Both controls (DistributorName and Technician) should be combo boxes whose
data source is a query). The DistributorName query should be something like
'SELECT distributor FROM tblDistributors ORDER by distrinutor'. The
Technician query should be something like 'SELECT technician FROM
tblTechnicians WHERE distibutor = [Forms]![MyForm]![MyDistributorControl]
ORDER by technician'. You will need a distributor table and a technician
table and the technician table needs to contain the distributor as a column.
Needless to say, this is a vastly simplified explanation. You need the
tables and relationships set up to suport this.

-Dorian

"Leslie" wrote:

In my form I have a field called DistributorName and a field called
Technician. Each Distributor has multiple technicians. I want to have a
drop down list of the technicians specific to the Distributor to fill in
after the Distributor Name is choosen. We are using Access 2006. For
example.

FRM_CallLog has a DistributorName Field(object) and then it has a Technician
Field (Object). The Distributor name field is a list of current Distributors
and the person logging a call would choose a Distributor on the list to
populate the Distributor Name field. then based on the Distributor Name that
was choosen the Technician Field would create a list of active technicians
for that DistributorName and the person logging the call would choose the
name of the Technician that they talked to. How can I accomplish this? I
tried DLookup but that does not work and doesn't give the option to pick one
name from the list. Any help would be greatly appreciated.

Thanks,