Tina Norris Fields
tinanfields at torchlake.com
Mon Feb 23 17:21:10 CST 2009
Thank you, William. Tina William Hindman wrote: > 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 >> >> > >