Say I have a tblCustomers and tblSales.
tblCustomers has: CustomerID, CustomerName, CustomerAddress,
CustomerPhone
tblSales has: CustomerID, SalesOrderNo, SalesDate, ProductID,
CustomerName, CustomerAddress, CustomerPhone.
The tables are linked with CustomerID.
How can I create a form getting data from both tables, and enetring
the data to the tblSales.
Using the form I will be able to change CustomerName, CustomerAddress,
CustomerPhone, but this will be changed on tblSales only (and not in
tblCustomers).

Any help here would be greatly apprecaited!

Thanks,

Galsaba

On May 19, 8:17*am, galsaba <gals... (AT) gmail (DOT) com> wrote:
G,

Before we launch into a lesson on Relational Databases. Are you
suggesting you want to be able to have a separate name, address, and
phone number saved in tblSales. (i.e. like an invoice that stays with
the old info, even if the customer changes their info later.)

Jon

On May 19, 10:21*am, jonceramic <joncera... (AT) gmail (DOT) com> wrote:
Yes, exactly as you described.

Thanks,

galsaba