[AccessD] A Design Opinion, Please

...if the business rules don't include allowing an outside sales person to 
designate the customer lead, this would be my approach as well.

William

--------------------------------------------------
From: "Susan Harkins" <ssharkins at gmail.com>
Sent: Saturday, February 21, 2009 7:54 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] A Design Opinion, Please

> Why not just revamp the underlying query to include the lead salesperson 
> and
> add it as a text field?
>
> Susan H.
>
>> 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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>