awroblew
05-03-2006, 02:43 PM
software: abcDB DesktopStudio
platform Pocket PC 2003
tables:
equipment:
eqID equipment
1 CPU
2 monitor
3 printer
etc...
type:
typID eqID type
1 2 15in
2 2 17in
3 2 21in
4 1 Desktop
5 1 Laptop
6 1 Server
goal:
Create form with dropdown lists:
equipment and type
where if you select equipment CPU in type dropdown you'll see only:
Desktop,
Laptop,
Server
how can I do this with SQL ? What would be the syntax
I've got really basic knowledge about SQL and unfortunatelly not enough time to learn more.
Please help
Big thanks for any clues
platform Pocket PC 2003
tables:
equipment:
eqID equipment
1 CPU
2 monitor
3 printer
etc...
type:
typID eqID type
1 2 15in
2 2 17in
3 2 21in
4 1 Desktop
5 1 Laptop
6 1 Server
goal:
Create form with dropdown lists:
equipment and type
where if you select equipment CPU in type dropdown you'll see only:
Desktop,
Laptop,
Server
how can I do this with SQL ? What would be the syntax
I've got really basic knowledge about SQL and unfortunatelly not enough time to learn more.
Please help
Big thanks for any clues