Dealing with repetitious data

[Guest]

I am setting up a database with a data entry form.
I've set up the form with about 8 text boxes -- Customer Name, ID#, Flow rate, etc... (you get the idea).
The data entered often comes in groups (such as 'Customer Name' the same for several records).

What I would like the Form to do is to fill out a new form with the data from the previous record. I could then modify the parts that are unique.

I'm sure this has been done before

 

[Sam D]

Yep, it has been done before, but it's the wrong way of going about it.

Every customer name should only exist once in your database. Sounds like you
need to read about relational databases and normalising. There's heaps of
links on the Internet.

Might sound a bit boring, but in the long run it will save you numerous
future headaches!

HTH
Sam

I am setting up a database with a data entry form.
I've set up the form with about 8 text boxes -- Customer Name, ID#, Flow

rate, etc... (you get the idea).

The data entered often comes in groups (such as 'Customer Name' the same for several records).

What I would like the Form to do is to fill out a new form with the data

from the previous record. I could then modify the parts that are unique.