Update customer billing address

[Christopher Glaeser]

I am implementing a simple invoice system in Access. When a customer has a
new billing address, what is a simple approach such that old invoices
already in the system with the old address retain the old address, and any
new invoices use the new address?

Best,
Christopher

 

[PC Datasheet]

TblCustomer
CustomerID
Name
BillingAddress

TblInvoice
InvoiceID
CustomerID
BillingAddress

Keep the BillingAddress in TblCustomer always current. When you create an
invoice record, record the customer's current billing address from TblCustomer
in TblInvoice. If a customer's billing address changes, previous invoices will
have the old address and new invoices will have tht new address.

Please take the time to look at my website and if you would ever like my help,
contact me at the address below.