Recalling data in a form

[Bhagya]

Hi,

I have a form which stores purchase information, this form
also have the customer's address and other related data.

My problem is for a new purchase, I have to reenter the
customer's information again. Is there a way around this?

A way in which if I select the customer id then the old
information comes up- I make a few changes in the form and
then save this as a new record?

Any help is appreciated.

Thanks
Bhagya

 

[Gary Miller]

Bhagya,

You have a design problem here. You need to have a table that holds all of
your customers and then another one for their purchases that is related by
the CustomerID. You would then use some variation of a Form/Subform to pull
up the customer and enter the purchases. This is a one to many relationship
between the customer and their purchases.

Gary Miller