Hi all, i created a table (columns:part_no, part_desc, pi_loc) whereby part_no field has unique values. But, now need to add one more column "customer" and the part_no will have duplicates. And, we need to verify new entries by checking the part_no and customer fields (which tied together is unique). How to handle this? Pls help anyone.
shena
0
Junior Poster in Training
Begginnerdev
256
Junior Poster
What database type are you using: Access, SQL Server, Oracle, or something else?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.