You can handle that with a Null employee in an employee-phone link table and phone status of "in Repair", "in stock" etc. On 25 Sep 2020 at 11:22, David McAfee wrote: > > Phone 1 is with Joe, which gets dropped. > It gets assigned to quarantine/repair > Phone 2 gets assigned to Joe. > Phone 1 is now repaired and is assigned to "unassigned"