[AccessD] A Design Opinion, Please

...I learned the hard way never to set a lookup in a table field :(

William

--------------------------------------------------
From: "Tina Norris Fields" <tinanfields at torchlake.com>
Sent: Saturday, February 21, 2009 7:01 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
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
>