How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1999
Experience:  20 years experience providing remote computer support
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

you any good at ERD diagrams? you know the ones that show the

Resolved Question:

you any good at ERD diagrams? you know the ones that show the cardinality that will be a separate question of course.
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  The-PC-Guy replied 5 years ago.
let me finish the query thing first
Customer: replied 5 years ago.
ok great
Expert:  The-PC-Guy replied 5 years ago.
here is how the sql from the previous question should be, I just don't
know how to do this in access.

The idea is that the user will select a category from a drop down on
the report, I already created this drop down and populated it. What it
should do is update the list of books on the report when the user selects
a new category

we will call the value of this "reportlist.value"

SQL statement 1

SELECT BOOKLIST2.Categories_ID FROM BOOKLIST2 INNER JOIN Categories ON BOOKLIST2.Categories_ID = Categories.ID
WHERE reportlist.value = Categories.Book categories description;

this will give you the category ID based on the category selected. then inorder to get the list of recommendations updated
we need to take this value we will call it SQL result 1 and plug it into this query

SQL statement 2 using result from SQL statement 1

SELECT BOOKLIST2.BOOKS TITLE, BOOKLIST2.Authors, BOOKLIST2.COST OF BOOK, Categories.Book categories description
FROM Categories INNER JOIN BOOKLIST2 ON Categories.ID = BOOKLIST2.Categories_ID
WHERE Categories.Book categories description = SQL result 1;

this is not the best way of doing this but its functional, again access is difficult to work with.

As for your ERD you can just do a screen capture of the relationships screen.

The DB is not set up very well, not sure where you got the sample data from, but basically its not in good 3NF its not
even in good 2NF. The relationships are the best I could make them now with the given table structure.

The-PC-Guy and 4 other Microsoft Office Specialists are ready to help you