Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Create "Layered" Variable Limits?

Status
Not open for further replies.
marcmoore

marcmoore

Programmer
Dec 16, 2002
1
US
Let's say that I have 2 variable "show values" limits in my query that go against a State table and a County table, respectively. How do I limit selection from the database for the County limit to those counties in the State selected by the user?
 
Sort by date Sort by votes
This will work when State limit is to the left of the County limit in the same query.
1. Set the State limit from the State list box.
2. Repopulate the County list box.

hth,

David
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Loanpro
  • Locked
  • Question
Passing + sign to .csv file
Replies
0
Views
83
Loanpro
Loanpro
sa0309
  • Locked
  • Question
Passing an Oracle SP error message to Informatica Email Task
Replies
0
Views
94
sa0309
sa0309
sa0309
  • Locked
  • Question
Router Output to a "Single Target Table"
Replies
1
Views
84
rasETL
rasETL
donafran
  • Locked
  • Question
How to code a condition in Sequence Job ??
Replies
1
Views
148
donafran
donafran
rickeybj
  • Locked
  • Question
Is there a way to transfer files from and old Tandy word processor to a PC?
Replies
2
Views
109
rickeybj
rickeybj

Part and Inventory Search

Sponsor

Back
Top