Search results

Hello I have two tables: One (Books) containg the fields BookID, Title, Domain. ClassCode. The second (Domains) contais the fields ClassID, ClassCode, Domain The two tables are in a one-to-many relationship, so I can use multiple Titles for the same ClassCode. I have a form to add data in the...

Thank you all for help I am taking it one step at a time, based on George relationships diagram. A title may have none, one, or many authors An author may have written many books So in this case I have a many-to-many relationship, using Table_Author_Junction as junction table. I quite do...

Pat Hartman multiple authors, not publishers

I am trying to figure out the best structure for the following issue. I have a database of a bookstore (a library) for each book, i have to store the following data: Title Authors Publisher year Domain Inventory_No All tghese fields may have duplicates (Same title for different books, same...

Thank you arnelgp Works like a charm. Please check MajP solution too. Do you thing it is a bettrer structural approach? MajP, this may be an approach, but in this case, Inventory_No would not be the PK for the main table, so I should use a labeling sistem for the book title.

Hello, I have a database for recording books in a library Each record have the following fields: Inventory_No > Primary key (no duplicates) Timestamp Title (duplicates allowed) Author (duplicates allowed) Year I am not allowed to enter quantity, so if i have 25 copies of the same book, i must...