AnsweredAssumed Answered

One to one relationship showing records not already assigned in a conditional value list

Question asked by cthomassin on Dec 23, 2017
Latest reply on Feb 2, 2018 by arthurlaurent

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.

 

Thank you.

Outcomes