Sample Header Ad - 728x90

See direct (instead of indirect) info about rented book in my "actors_directors" talbe dropdown list - Access365

0 votes
1 answer
150 views
I'm building a database of "actors_directors" who are renting "books" from my library - a kind of exercise to learn database basics :-) This is how my "actors_directors" table looks like. They are the customers who are renting the books from my library. Index field is a primary key in this table. This is how my There are books listed in different table called "books" and similarly "Index" field is a primary key in this table. This is how my Finally I have all the instances of the book being rented in my third table "checkouts". Please ignore the last three columns there. Similarly "Index" field is a primary key in this table. "ForeignKeyCustomer" column refers to Index column in "actors_directors" table and its one-to-many relationship. "ForeignKeyBook" column refers to Index column in "books" table and its one-to-many relationship. This is how my These are relationship I've set for my tables. This is how actors_directors with checkouts table relationship looks like. Now after I unfold the pluses in the "actors_directors" table like it's shown in the next picture, there are not exactly the info I wanted to see. What I see is the number of the book, some specific actor rented, while I'd like to see the title of this book. 05 - actors_directors relations but not what I wanted Instead of info about "ForeignKeyBook" - the book's number, I'd like to see it's Title in this place. But the info about the title is in different table. Can U help me with that? I don't want to see the book's number, because it tells me nothing. I want to see the book's title, that is in different table, but also the "CheckOutDate" and "RentPeriod" and "RentFee" from this "checkouts" table, that's related/linked in my current situation (this screenshot). 06 - how to add book's title to all these info, without deleting the info sourced from Thanks in advance my friends.
Asked by michal roesler (125 rep)
Nov 12, 2019, 10:59 PM
Last activity: Nov 13, 2019, 01:40 PM