By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 995 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

Possible to SELECT all tables?

P: 40
Hello,

I'm curious to know if there is a way to select all tables when using a query in access. I have some (unsuccessful) cascading combo boxes and need a little help maybe working out the query. I am familiar with database concepts, but am new to Access. The problem is in the query statement. I'm not sure what to put after FROM because it would depend on the user's entry.

I would need it to look something like this, but my needs/wishes/wants aren't going to change the SQL structure. =)

SELECT * FROM (all tables here? or could I list them like tbl1, tbl2, tbl3...?)
WHERE * = cbo.Employee(meaning whatever employee the user chose in the combo box)
I need it to do this because an employee might be cross-trained in multiple departments.
Is it possible to do something like this?

Also, I have a subform on that particular form with the cascading combo boxes and I would like to make the two relate. Meaning, if I select an employee or department from the combo box, it brings up the employees or dpearment's info in the subform.

If it would help any of you to have a screenshot or me to link the hosted file, just let me know.

Thanks in advance.
Jun 7 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,616
Hello,

I'm curious to know if there is a way to select all tables when using a query in access. I have some (unsuccessful) cascading combo boxes and need a little help maybe working out the query. I am familiar with database concepts, but am new to Access. The problem is in the query statement. I'm not sure what to put after FROM because it would depend on the user's entry.

I would need it to look something like this, but my needs/wishes/wants aren't going to change the SQL structure. =)

SELECT * FROM (all tables here? or could I list them like tbl1, tbl2, tbl3...?)
WHERE * = cbo.Employee(meaning whatever employee the user chose in the combo box)
I need it to do this because an employee might be cross-trained in multiple departments.
Is it possible to do something like this?

Also, I have a subform on that particular form with the cascading combo boxes and I would like to make the two relate. Meaning, if I select an employee or department from the combo box, it brings up the employees or dpearment's info in the subform.

If it would help any of you to have a screenshot or me to link the hosted file, just let me know.

Thanks in advance.
You must provide more information than this before anyone can provide an answer (Table Names, Relationships, Linking Fields, etc..)
Jun 14 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.