[AccessD] A Design Opinion, Please

http://www.mvps.org/access/lookupfields.htm

William

--------------------------------------------------
From: "Tina Norris Fields" <tinanfields at torchlake.com>
Sent: Sunday, February 22, 2009 12:19 PM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] A Design Opinion, Please

> Thanks to William, Susan, and Dan for your replies.
>
> The setup is, indeed, that the outside sales people need to know who the
> primary sales person is.  In fact, the outside sales people's data entry
> form shows a textbox for the primary sales person.  That is a field in
> the underlying table.  The main data entry form, not accessible to the
> outside sales people, does not have the textbox for that field, which is
> why the information has not been getting into the table.  I am adding
> that information to the main data entry form.  To make certain that the
> correct code is selected for the primary salesperson, I want to use a
> combobox for the selection.  I thought I would put a combobox on the
> form to select the correct salesperson and have that store the
> information in the appropriate field in the table.  Then I thought maybe
> I would modify the table and make that field a lookup field which would
> make the selection on the form very easy.
>
> Noodling over which choice would be the better, I turned to you all.
> William, you said you learned the hard way never to set a lookup field
> in a table.  Please tell me why - that sounds like just exactly the
> lesson I need.
>
> Tina
>
> William Hindman wrote:
>> ...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
>>>
>>>
>>
>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>