[AccessD] A Design Opinion, Please

Hi Tina,

It sounds like your app is accessed both by people who know who the primary
sales person, and also by people who may not know but need to know.

How about this:

Your Customer table should have a field for PrimarySalesPerson, and that
field should contain this person's name.

In the form, when a customer is selected, then the Primary Sales person will
display in a combobox, where the combobox is bound to the PrimarySalesPerson
field.  If there isn't a Primary Sales Person, then the field will be blank,
indicating that no one has been selected - the inside sales people can then
select someone.  If there is a person listed but they are now incorrect,
then your inside people can change who it is.

So, your outside people will also know who the current Primary Sales Person
is (or that there isn't one) immediately after the Customer is selected.

The Customer table will be the data source for the form, and a separate,
non-related lookup table of all Sales People will be the Row Source for the
Primary Sales Person combobox.

Hope this helps!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
Fields
Sent: Saturday, February 21, 2009 6:02 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] A Design Opinion, Please

Hi All,

On a data entry form, where a choice should be made to identify the 
sales staff person primarily responsible for a particular customer, 
which of these methods is better and why?

Method 1 - set the sales staff field in the table to be a lookup field
Method 2 - place a combobox on the form that looks up the sales staff 
and then updates the field in the table.

This is a remodeling job.  The outside sales people need to know who the 
lead sales staff person is on any given customer.  However, at present 
the main data entry form does not indicate that information.  I'll be 
making this change, and I got to thinking about which approach would be 
the wiser of the two. 

Thanks for your opinions.

Tina
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com