what is the name of this feature?

[Christopher Glaeser]

I have a very basic question about Access. Consider an invoice system that
has a table for customers and a table for invoices. When an invoice is
created for a customer, the customer's address is "copied" to the invoice so
that if the customer moves to a new address in the future, it does not
change the addresses on the old invoices. What is this copy feature called
and how is it implemented in Access?

Best,
Christopher

 

[Duane Hookom]

I'm not aware that this "feature" has a name and I don't think it can be
done without some code. Consider an invoice form bound to an invoice tables
that contain these fields:
CustomerID
CustAddress
CustCity
CustState
CustZip
You would select a customer from a combo box with columns like CustomerID,
CustName, Address, City, State, Zip. You would add code in the after update
event of the combo box to set the values of CustAddress, CustCity,... to
values from the combo box columns.
Me.txtCustAddress = Me.cboCustomerID.Column(2)
Me.txtCustCity = Me.cboCustomerID.Column(3)
Me.txtCustState = Me.cboCustomerID.Column(4)
etc.
The columns are numbered from 0.