C
Carolyn
Hi - I'm not sure if I'm describing this well, but I
would like to be able to filter the choices in a combo
box based on the record that is selected in the form.
Basically, I have a main table that contains business
names. Then I have a subtable that has addresses, and a
subtable that has employee names (I set it up this way so
that the addresses are associated with the business, not
the employee so that you don't have to have an employee
record in order to create an address record.) I want to
create a way, though, to link employees to addresses, so
I created a form based on the businesses, with a subform
that consists of a join table of the address ID numbers
and the employee ID numbers. I want to create combo
boxes in the subform for addresses and employees that
show only the addresses and employees for the business
selected on the main form. Right now, I get all of the
employees in the database and all of the addresses in the
database - it works, but it's not ideal.
Does this make sense?
Thanks-
Carolyn
would like to be able to filter the choices in a combo
box based on the record that is selected in the form.
Basically, I have a main table that contains business
names. Then I have a subtable that has addresses, and a
subtable that has employee names (I set it up this way so
that the addresses are associated with the business, not
the employee so that you don't have to have an employee
record in order to create an address record.) I want to
create a way, though, to link employees to addresses, so
I created a form based on the businesses, with a subform
that consists of a join table of the address ID numbers
and the employee ID numbers. I want to create combo
boxes in the subform for addresses and employees that
show only the addresses and employees for the business
selected on the main form. Right now, I get all of the
employees in the database and all of the addresses in the
database - it works, but it's not ideal.
Does this make sense?
Thanks-
Carolyn