I have an order form that needs  to have a subform where I can select the data from one of several credit cards on file for each customer.  It needs to insert those fields into the subform and allow me to edit the fields, if necessary, and save the fields in the OrderT table.    The fields saved in the OrderT need to be protected so that future changes to the credit card data does not also change the data in each order record.  
How would you recommend setting this up?  Did Richard have a seminar that covered something similar?

---

Reply from Alex Hedley:

This does sound Familar but may not have been covered in the recent videos as he prob did it with some VBA
Or it was in one of the Seminars.
If you want to keep historic info you'll need to add those Fields to the OrderT then have a button that copies across the chosen card into those Fields
Was this done with Shipping Address?
Refresh my memory fellow students :)