Getting data 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

 

[Dale Fye]

See my reply in the Formscoding newsgroup.

If you feel you need to post a message to more than one newsgroup, do it all
in one message, with multiple newsgroups listed on the same address line,
separated by semi-colons. This technique is called cross-posting, and is
considered good netiquette, so long as you don't post to more than a couple
of groups. There are several advantages to this:
1. Only one message, posted to multiple newsgroups. No matter what group
someone sees the message on and responds to it in, everyone in the other
groups that received the message will also see all the responses.

2. It actually makes it easier for you too, less typing and you don't have
to check multiple newsgroups.

The method you used is called multi-posting, and is frowned upon.

HTH
Dale

 

[Duane Hookom]

There is no reason to set the first and last names as the primary key. I use
autonumber primary keys on my "people" tables all the time and users never
see the primary key field value.

To see a demo of how to use "cascading" combo boxes, check the samples at
Roger Carlson's site www.rogersaccesslibrary.com.