gvp16 Posted November 1, 2011 Share Posted November 1, 2011 Hi, all, I have a table that has a list of kits and their parts like so : KitCode, KitPrice, Part1, Part2, Part3, Part4, Part5, Part6, Part7, Part8, Part9, i then have a shopping basket with parts in: Part1 Part2 Part3 How can search to find it a kit has all the parts i have in my basket? Thanks. Quote Link to comment Share on other sites More sharing options...
fenway Posted November 1, 2011 Share Posted November 1, 2011 You normalize your database. Quote Link to comment Share on other sites More sharing options...
gvp16 Posted November 1, 2011 Author Share Posted November 1, 2011 can you please explain how that will help? each row already has its own identifier and there are no duplicates. Quote Link to comment Share on other sites More sharing options...
fenway Posted November 1, 2011 Share Posted November 1, 2011 You have part1...part9 -- those are duplicates. Quote Link to comment Share on other sites More sharing options...
gvp16 Posted November 1, 2011 Author Share Posted November 1, 2011 How? if part1 = 3641-001 part2 = 3646-001 part3 = 3647-001 how are they duplicated? Quote Link to comment Share on other sites More sharing options...
mikosiko Posted November 2, 2011 Share Posted November 2, 2011 this should help you to understand better... http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx scroll down and read about Normalization... specially about First Normal Form (1NF) and repeating groups Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.