Using Combo Boxes

  • Thread starter Thread starter Praveen Manne
  • Start date Start date
P

Praveen Manne

Hi,

I have 2 tables;
1. Demo: ID, LastName, FirstName (fields in the table Demo) ID is the
Primary key.
2. Orders: Last Name, First Name, NoOfOrders .......

I chose Last Name and First Name as the primary fields because I want the
users of this application, be able to select the Names from a combo box
instead of selecting their ID's.

Here I have 2 problems,

1. when I select Last Name in the first combo, it should filter the values
in the First Name combo. ( I tried so many ways to do this, but I failed all
the times)
2. And when the First Name Combo got selected, I want the SSN textbox field
which is empty, should populate the correct SSN value from the first table.

Please Help

Thanks
Praveen Manne
 
Praveen Manne said:
Hi,

I have 2 tables;
1. Demo: ID, LastName, FirstName (fields in the table Demo) ID is the
Primary key.
2. Orders: Last Name, First Name, NoOfOrders .......

I chose Last Name and First Name as the primary fields because I want the
users of this application, be able to select the Names from a combo box
instead of selecting their ID's.
Click to expand...

I once worked in a store with two "Donald Leroy Smiths"
Use an auto number, SSN or almost anything else except a first and last
name.

Use a combo box with the names sorted to select the SSN if you don't know
it.
Even with 20,000 names and looking up "Smith" it will be east to find.
 
Praveen:

If you send me your email, I'll mail you an example db that accomodates this
scenario.

Tom
 
Hi Tom,

My email is (e-mail address removed) . Thanks for your response.

Thanks
Praveen Manne
 
Back
Top