Copy/Cancel info

[jwr]

I have a form named Customer. There are times when the customer info is
duplicated for another order. Is there a way to "copy" the info from
customer i.e. Customer 1 Info copy to Customer 3? Also, is there a command
I can create that -- if the customer needs to be deleted -- will
automatically delete the customer?

Thank you

 

[Michel Walsh]

Hi,


If you mean "for Order #3, copy the customer information from Order #1",
then you may decide to make another table, for the customer info, and, in
your table or Orders, have a REFERENCE to the Customers table. Doing so, you
won't have to repeat the info multiple times:


Customers 'table name
CustId, Info 'fields name
1 "Bill Gates"
2 "Joy Rose"
.... data sample


Orders
OrderId, CustID, ... ' fields name
101, 1, ...
102, 1, ...
103, 2, ...

so, for Order 101 and for order 102, the customer is the same, and a simple
join between the two tables supplies the "link" to the information stored in
the Customers table.


Hoping it may help,
Vanderghast, Access MVP