Re: For MVP: data entry from combo box line items

From: Roger Carlson (NO-carlsoro-SPAM_at_hotmail.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 09:05:06 -0500

Well, you're free to do as you wish, but I would strongly caution you
against storing these values as second time. It violates the rules of
normalization, which exist because they work. 

-- 
--Roger Carlson
  www.rogersaccesslibrary.com
  Reply to: Roger dot Carlson at Spectrum-Health dot Org
<anonymous@discussions.microsoft.com> wrote in message
news:0e3e01c3fb4c$4c738030$a501280a@phx.gbl...
> Roger,
>
> Both your responses are neat, simple, and much
> appreciated. Don't know why I still feel paranoid about
> seeing Customer ID's in a table without the associated
> name, but I still do. Looks like I could also customize
> your second solution to cause a post to bound text boxes
> rather than only to unbound. Thanks again ...
> >-----Original Message-----
> >Well, I'm not an MVP, but...
> >
> >There is no need to need to copy the FirstName and
> LastName into the other
> >table, if that's what you're thinking.  Storing the ID is
> enough.  You can
> >join the tables back together later in a query or report.
> >
> >However, there is no problem with simply *displaying*
> those values.  There
> >are a number of ways to do this.  One would be to have
> the first and last
> >name text boxes (txtFirst and txtLast) remain unbound.
> Then in the
> >AfterUpdate Event of the Customer ID combo box do
> something like this:
> >
> >Me.txtFirst = cboCustomerID.Column(1)
> >Me.txtLast = cboCustomerID.Column(2)
> >
> >
> >-- 
> >--Roger Carlson
> >  www.rogersaccesslibrary.com
> >  Reply to: Roger dot Carlson at Spectrum-Health dot Org
> >
> >
> >"Bill Morgan" <willmorgan@lisco.com> wrote in message
> >news:096101c3fb09$791bac40$a501280a@phx.gbl...
> >> Problem: I need to ensure that data entry personnel
> always
> >> enter the Customer LastName and FirstName that
> correspond
> >> to that Customer's ID Number.
> >>
> >> They pick (click on) the Customer ID from a combo box
> that
> >> is three columns wide and also lists the Customer
> LastName
> >> and FirstName. The combo box is based on a query that
> >> comprises all Customer ID's, LastNames, FirstNames, and
> it
> >> is bound to the Customer ID field on the form's
> underlying
> >> table. When they click on the Customer in the combo box,
> >> the Customer ID posts to the Customer ID field (text
> box).
> >>
> >> What is the cleanest/simplest way to make the Customer
> >> FirstName and LastName (columns 2 and 3 of the combo
> box)
> >> also automatically post to the forms LastName FirstName
> >> fields at the same time that the Customer ID posts?
> >>
> >> Thanks for any help youc an provide ...
> >>
> >> Bill Morgan
> >> willmorgan@lisco.com
> >>
> >>
> >
> >
> >.
> >