Using Combo Boxes

[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

 

[Mike Painter]

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.

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.

 

[Tom]

Praveen:

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

Tom

 

[Praveen Manne]

Hi Tom,

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

Thanks
Praveen Manne

 

[Tom]

Praveen:

Sent the attachment to your email listed below.

Tom

 

[Praveen Manne]

Thanks TOM

Praveen Manne

Praveen:

Sent the attachment to your email listed below.

Tom