Hi, I have a book table and a ISBN number table with 100 numbers ready to be assigned. Each book has one and only one ISBN number. And a ISBN number is allocated to one et only one book. It is a one-to-one relationship.
My question is: How can I show up in my Book layout a pop up value list with the ISBN numbers not already allocated to a book to avoid a IBSN number related to more than one book.