| Problem with Dynamic LOV in WebDB 2.2 [message #364988] |
Mon, 31 July 2000 13:51 |
pygmyfish
Messages: 2
Registered: July 2000
|
Junior Member |
|
|
Hi All,
I have a sports teams database. On one form, users enter the league information, then, they need to enter the team information. I want to restrict the team LOV to those teams associated with the league that was just entered. Does anyone know the syntax required to do this?
The query looks roughly like:
select team_name, team_id
from teams a
where a.league_id = :league_id
I thought ':league_id' would reference the value entered in the form, but I can't get it to work. I've tried a variety of other syntax too. Help!!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
