How to keep invoices and what was charged for a product from changing when you need to change a product price. These are 3 separate tables that use lookups to reference each other.
Products
Name
Current Price
Name
Current Price
Hoodie
$65.00
Pant
$48.00
Beanie
$22.00
There are no rows in this table
Products Price Table
Product
Price as of
Price
Product
Price as of
Price
Hoodie
1/1/2018
$55.00
Hoodie
2/7/2019
$60.00
Pant
9/19/2019
$48.00
Hoodie
9/18/2019
$65.00
Beanie
9/5/2018
$22.00
There are no rows in this table
Invoice Table
Invoice Number
Product
Invoice Date
Price per Product
Quantity
Currency
Invoice Number
Product
Invoice Date
Price per Product
Quantity
Currency
#1001
Hoodie
8/7/2018
$55.00
3
$165.00
#1002
Hoodie
5/10/2019
$60.00
3
$180.00
#1003
Hoodie
9/19/2019
$65.00
3
$195.00
There are no rows in this table
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
