help
-
Sir i have created 4 tables in which 1 is the master table Case table 1 : Author_id (P.K) Author_name Table 2 : Pub_id (p.k) Pub_name table 3 : Book_id (p.K) Book_name Table 4 ( master Table) MBD (p.k) Book Name ( drop down box) Author Name ( drop down Box) Pub name ( drop down box ) Qty Price ==================================== as you seen in the 4th table i have to add the book name( from table 1), pub name(from table 2) and author name(from table 3). in the table 4 i don't want to store their names i want to store their ID ..... book_id, pub_name, author_name.... any suggestion friends ? Thanks
-
Sir i have created 4 tables in which 1 is the master table Case table 1 : Author_id (P.K) Author_name Table 2 : Pub_id (p.k) Pub_name table 3 : Book_id (p.K) Book_name Table 4 ( master Table) MBD (p.k) Book Name ( drop down box) Author Name ( drop down Box) Pub name ( drop down box ) Qty Price ==================================== as you seen in the 4th table i have to add the book name( from table 1), pub name(from table 2) and author name(from table 3). in the table 4 i don't want to store their names i want to store their ID ..... book_id, pub_name, author_name.... any suggestion friends ? Thanks
Redesign your data, lesson 101 of normalised data is that you only store information 1 time table 4 should have BookID, AuthorID and PubID not the information. BTW I hope that is not the name of your table. If you want to learn about this try and get hold of microsoft Pub demo database, it deals with this exact industry. Also please read the guidelines for posting.
Never underestimate the power of human stupidity RAH
-
Sir i have created 4 tables in which 1 is the master table Case table 1 : Author_id (P.K) Author_name Table 2 : Pub_id (p.k) Pub_name table 3 : Book_id (p.K) Book_name Table 4 ( master Table) MBD (p.k) Book Name ( drop down box) Author Name ( drop down Box) Pub name ( drop down box ) Qty Price ==================================== as you seen in the 4th table i have to add the book name( from table 1), pub name(from table 2) and author name(from table 3). in the table 4 i don't want to store their names i want to store their ID ..... book_id, pub_name, author_name.... any suggestion friends ? Thanks
-
Redesign your data, lesson 101 of normalised data is that you only store information 1 time table 4 should have BookID, AuthorID and PubID not the information. BTW I hope that is not the name of your table. If you want to learn about this try and get hold of microsoft Pub demo database, it deals with this exact industry. Also please read the guidelines for posting.
Never underestimate the power of human stupidity RAH