Forum Discussion
Lookup Wizard for Multiple Columns
Hi all, I've been using Access for less than a month and have a school project to finish. I have to make two tables for this database. One has a list of books along with author and ISBN while the...
As its a school project, I'm going to give you direct hints rather than a detailed solution.
However, from your description, it sounds like the discarded books will be listed in both tables.
Doing that is duplication of data and poor practice in database design. Based on your description, only one table is needed
Identify your discarded books by adding a Yes/No (boolean) field and call it Discarded. Tick the checkbox for discarded books.
Create a query to show a list of book titles, authors and ISBN values for all books where Discarded=True
However, from your description, it sounds like the discarded books will be listed in both tables.
Doing that is duplication of data and poor practice in database design. Based on your description, only one table is needed
Identify your discarded books by adding a Yes/No (boolean) field and call it Discarded. Tick the checkbox for discarded books.
Create a query to show a list of book titles, authors and ISBN values for all books where Discarded=True