[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
>>
>>     
>
>