orbic1
Registered User.
- Local time
- Today, 02:04
- Joined
- Mar 3, 2004
- Messages
- 46
Okay - here's my predicament!
I have 4 tables, each dedicated to a different level of personel. These need to be discreet! The other functions that I use them for wont work if they are all in one table. I need to generate either one of the following:
1) Either a list of all of their names, pulling from each table. I've tried various "SELECT FROM" SQL statements to no avail.
2) The cascading combo box option (ideal option) whereby dependant upon a previous box describing the type of personel (same name as associated table), the relevant list of names appears. I'm not the best at cascading combos at the best of times, but I can get them to work. This, however, I can't as it braches accross several tables!
Thanks for looking at this! Any ideas? I would be most grateful for any suggestions!
I have 4 tables, each dedicated to a different level of personel. These need to be discreet! The other functions that I use them for wont work if they are all in one table. I need to generate either one of the following:
1) Either a list of all of their names, pulling from each table. I've tried various "SELECT FROM" SQL statements to no avail.
2) The cascading combo box option (ideal option) whereby dependant upon a previous box describing the type of personel (same name as associated table), the relevant list of names appears. I'm not the best at cascading combos at the best of times, but I can get them to work. This, however, I can't as it braches accross several tables!
Thanks for looking at this! Any ideas? I would be most grateful for any suggestions!
Last edited:
