Two combo boxes and Master-detail tables

From: Bud (bud_at_spaceintelnospam.com)
Date: 01/22/04 

Date: Wed, 21 Jan 2004 22:48:07 -0500

Hi All,

I have a master and a detail table. Master table is a US state table, all 50
states and some population attibutes, and the detail table is US counties.
The two tables are linked via state name.

What I want to do is to have two drop-down combo boxes. The one shows all 50
states. You choose one from the state drop-down box, and the county
drop-down box will show ONLY those counties in the selected state.

Spent an hour or so on this and still going nowhere. Any tips?

Thanks.

Bud

Relevant Pages

  • Re: Two combo boxes and Master-detail tables
    ... and the detail table is US counties. ... You choose one from the state drop-down box, ... CountyCBO has its listSource set to the CountyTable.datasource. ... Both have their Keyfield property set to the appropriate field., ...
    (borland.public.delphi.database.ado)
  • Drop-down box
    ... Is there a way to set up a form with two drop-down boxes where when you enter ... information in the first drop-down box it will give you the associated ... counties in that state to select from. ...
    (microsoft.public.word.docmanagement)