Can you please help me come up with a way to keep track of my receipt and invoice transactions to enable the users of these reports to track the sequence of events. I would like to avoid the use of macros if possible.
If you take a look at the attached image, the tbleTransactions table is currently not linked to either tblInvoice or tbleReciept. I was thinking of placing both InvoiceID and ReceiptID into tblTransactions table but that would leave me with null values if i enter transactions for an Invoice and vice versa.
Your assistance is greatly appreciated.