Create a data trigger (or form code if triggers are not available) that adjusts inventory quantity on hand whenever an item is sold. You need a SaleItem and Item table. Create a table for...

Create a data trigger (or form code if triggers are not available) that adjusts inventory quantity on hand whenever an item is sold. You need a SaleItem and Item table.

Create a table for LoanPayments(LoanID, PaymentNo, DateDue, Amount). Write a function that is called whenever a new loan is created, to load the payments table with the scheduled payments and amount due.