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

Table Filtering

P: n/a
I am building a shipping and receiving database. I have a receipts
table and a movements out table. I have it set up so that when I
receive and item in it auto generates a Tag ID#. When I create a
delivery of that item, the next time I have a delivery, I do not want
that Tag# to show up in the drop down list since that item had been
delivered on a previous movement. I am new to Access and do not have
much VB experience.

Oct 27 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

jzint wrote:
I am building a shipping and receiving database. I have a receipts
table and a movements out table. I have it set up so that when I
receive and item in it auto generates a Tag ID#. When I create a
delivery of that item, the next time I have a delivery, I do not want
that Tag# to show up in the drop down list since that item had been
delivered on a previous movement. I am new to Access and do not have
much VB experience.
You don't need any code... just use an outer join.

SELECT TagID FROM Table1 LEFT JOIN Table2 WHERE Table2.TagID IS NULL;

Oct 27 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.