StrangePowers
New member
- Local time
- Today, 12:53
- Joined
- Apr 14, 2020
- Messages
- 6
Hi there,
I've only started building a database in Access a few days ago, so I'm real new at this. Through Youtube videos though I've been able to at least get all tables and queries for my library database in order. The problem I have is with the Form for lending out books. I have a table with "Books", but I also have a Table with "Copies"; since we have multiple copies for some of the books.
In the Form for lending new books, I've made a combo box where users can select the book they want to rent. I changed the row source so it has the CopyID in one column, and then the Title, First Name and Surname of the Author in the second, by typing this in the Builder:
Titel: [QRY_BÜCHER_IM_HAUS]![Titel] & "; " & [QRY_BÜCHER_IM_HAUS]![Vorname] & " " & [QRY_BÜCHER_IM_HAUS]![Nachname]
(I write in german, since that's where I'm from. In case it's unclear: I take everything from the query "QRY_BÜCHER_IM_HAUS" or, "books in".
The combo box now shows multiple similar titles (all witht their own unique CopyID behind the scenes), since of course, the CopyID is the identifying factor here, so switching the Unique Values of the query to Yes won't make a difference here.
Is there a way for me to show just one copy of each Title, and then automatically choose the lowest number in the CopyID of this book still available (I won't be adding an actual CopyID to the actual physical books, as I think this would just be too much work and it would mean an extra hassle for the end users. I also thought about just adding a lable telling users to just pick one of the duplicate titles at random, but I'm sure there's a more sophisticated solution)?
Your input would be greatly appreciated. This is my first post to this forum, so if I did anything wrong please excuse me, I'll be happy to correct any mistakes.
I've only started building a database in Access a few days ago, so I'm real new at this. Through Youtube videos though I've been able to at least get all tables and queries for my library database in order. The problem I have is with the Form for lending out books. I have a table with "Books", but I also have a Table with "Copies"; since we have multiple copies for some of the books.
In the Form for lending new books, I've made a combo box where users can select the book they want to rent. I changed the row source so it has the CopyID in one column, and then the Title, First Name and Surname of the Author in the second, by typing this in the Builder:
Titel: [QRY_BÜCHER_IM_HAUS]![Titel] & "; " & [QRY_BÜCHER_IM_HAUS]![Vorname] & " " & [QRY_BÜCHER_IM_HAUS]![Nachname]
(I write in german, since that's where I'm from. In case it's unclear: I take everything from the query "QRY_BÜCHER_IM_HAUS" or, "books in".
The combo box now shows multiple similar titles (all witht their own unique CopyID behind the scenes), since of course, the CopyID is the identifying factor here, so switching the Unique Values of the query to Yes won't make a difference here.
Is there a way for me to show just one copy of each Title, and then automatically choose the lowest number in the CopyID of this book still available (I won't be adding an actual CopyID to the actual physical books, as I think this would just be too much work and it would mean an extra hassle for the end users. I also thought about just adding a lable telling users to just pick one of the duplicate titles at random, but I'm sure there's a more sophisticated solution)?
Your input would be greatly appreciated. This is my first post to this forum, so if I did anything wrong please excuse me, I'll be happy to correct any mistakes.
Last edited: