I have developed a small inventory tracker (checks items in and out to people) and would like to see if it is possible to: Make it so that a new record for a particular item is not able to be created until the particular item has been returned. The database is done except for this rule if it is possible.