D
duncanjx
Hi there
I have a Customer table with the normal name, address and other
related information.
I want to allocate a staff member to the customer. I have set a LookUp
setting for STAFF Field as a field to select from table STAFF Details.
I use Staff Name as the primary Field as well.
What I want to do is to include Staff Location and Phone Number that
are linked to the Staff Field.
At the moment all staff details are in one table.
Ideally, from selecting from a drop down menu for the staff name I
want to bring up the other staff details without creating other STAFF
Location Field or STAFF Phone by a drop down.
I have set up a subform but do not like the look of it.
I want one selection from a combo box to populate all the information
about the staff member.
Any thoughts would be appreciated
Duncan
I have a Customer table with the normal name, address and other
related information.
I want to allocate a staff member to the customer. I have set a LookUp
setting for STAFF Field as a field to select from table STAFF Details.
I use Staff Name as the primary Field as well.
What I want to do is to include Staff Location and Phone Number that
are linked to the Staff Field.
At the moment all staff details are in one table.
Ideally, from selecting from a drop down menu for the staff name I
want to bring up the other staff details without creating other STAFF
Location Field or STAFF Phone by a drop down.
I have set up a subform but do not like the look of it.
I want one selection from a combo box to populate all the information
about the staff member.
Any thoughts would be appreciated
Duncan