How to create a field that if data is selected in one table from parent table in a child table it is not available for other child tables.
For example in a CD rent shop there are tables of costumers, CD'S, Loan, Return, Reserve.
Now a costumer wants to reserve a CD and the data from CD table is...