filter combo box to select second record?

  • Thread starter Thread starter ielmrani via AccessMonster.com
  • Start date Start date
I

ielmrani via AccessMonster.com

Hi,
I do not know if this is possible since I have never done it before.

I have combo box that contains one field (this field contains: MemberId and
MemberName like this:

12456898794, John, Smith
AB145789658, Karl, Bone
TA234587954, Anita, Sullf
54789897897, Paul, Tob

What I would like to do is allow the combo box to filter based on the
memberName.
If I type A I should be able to get This line: TA234587954, Anita, Sullf Not
AB145789658, Karl, Bone
I hope this is clear.
Thanks for all your help.

Dean
 
Dear Dean:

It is a fundamental rule of table design to keep each separate value in a
separate column. Lumping things together like this will result in queries
that are very difficult to write, and which cannot perform well because you
cannot create indexes needed for the sake of performance.

Put the MemberName in a separate column. When performance requires, you
should index by this column.

Tom Ellison
 
Yes, you're right. We'll do.

Tom said:
Dear Dean:

It is a fundamental rule of table design to keep each separate value in a
separate column. Lumping things together like this will result in queries
that are very difficult to write, and which cannot perform well because you
cannot create indexes needed for the sake of performance.

Put the MemberName in a separate column. When performance requires, you
should index by this column.

Tom Ellison
Hi,
I do not know if this is possible since I have never done it before.
Click to expand...
[quoted text clipped - 17 lines]
Dean
Click to expand...
Click to expand...
 
Back
Top