Data Pooling

FBueckert

New member
Local time
Today, 17:21
Joined
Aug 5, 2005
Messages
5
Hi. I'm trying to dump one field from two tables, into it's own table.

Explanation:
This is for inventory control. Each table is a different place, and the primary key on each table is the tag stuck onto each piece of inventory. So, since these are unique, I want it to check to make sure there are no duplicates, whatsoever, because the same thing can't be in more than one place at a time. Any ideas?
 
Design Issue.
Why would each table be a different place?
If you had a location field, and one table, you could make the Primary Key unique and that would solve your problem.
 
Yeah, figured that out about an hour after posting. Thanks, though.
 

Users who are viewing this thread

Back
Top Bottom