Create a record in different table every time a specific field value is unique?
I have an Orders table and a Ordered Items table. I would like for every time a new item record is added, if the due date doesn't match any other records' due dates, then a new record needs to be crea...