Listbox control help

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have two values im pulling from a query
Tutors FirstName and Tutors LastName
so it looks like this

FirstName|LastName
Brain |Lastname
shannon |Lastname
jean |Lastname
jason |Lastname

My problem is that the control only allows for one of
those two values to be passed into the database.
The database has a field for the tutor last name and first
name and I need them both yet for some unknown reason
microsoft chose to only let you use one value from the
list box :/ How do I pull both values and put them where I
need them?
If you can help please email me at (e-mail address removed), O
always loose the post on these news groups.
 
Hi,
Usually you would have something like a TutorId that would be stored as a foreign
key in any other other table that needs to relate to a Tutor.
You already have the full name stored in one table, there should be no reason to
store it again, only the TutorId (which should be the primary key of your Tutor's table).

Make sense? That's why you generally only need to store *one value* from the contents of a listbox
into any other table.
 
Back
Top