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

2 questions concerning multiple tables

P: n/a
I have 2 questions, the first is probably simple.
Let's say I have an employee table listing all employees and a sales
table listing employees that have made sales. How can I create a query
to show all employees that are not in the sales table?

The second question is this. Is there any way on an insert form, if a
certain record exists, to automatically insert that record into a
different table also entering a field from the existing record?
Thanks
Brian

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
For your first question, you can use the Find Unmatched Query Wizard.
On the Database Window, select Queries - new.

Your second question is a bit less clear -
perhaps you could give a specific example of what you want to achieve.
In general, unless data is changing and you want to keep a historical
record, it's counterproductive to store the same data in multiple places.
For instance, in the Sales table, you store the employee's ID, but not
his/her name.

HTH

"Brian" <br*******@charter.net> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I have 2 questions, the first is probably simple.
Let's say I have an employee table listing all employees and a sales
table listing employees that have made sales. How can I create a query
to show all employees that are not in the sales table?

The second question is this. Is there any way on an insert form, if a
certain record exists, to automatically insert that record into a
different table also entering a field from the existing record?
Thanks
Brian

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.