AutoFill from existing forms or tabes.

[Guest]

I’ve just started learning Access 2003 and would like to make a form with new
Customers and all their information, dealing with the window tinting business
I’m into.


Later if the SAME customer comes back with a new car, warranty work on the
previous car, or added work to the previous car, I like to make new forms
that can auto fill the same Customer info section and other repeat info from
just entering the primary key such like the phone number of the returning
customer or another suggested ways.

I don’t know any programming but am waiting for the book I order to start me
on my way. “Beginning Programming for Dummies†If that a good one or not more
suggestion are helpful to get me going in the direction I trying to
accomplish.

 

[Rick Brandt]

I've just started learning Access 2003 and would like to make a form
with new Customers and all their information, dealing with the window
tinting business I'm into.


Later if the SAME customer comes back with a new car, warranty work
on the previous car, or added work to the previous car, I like to
make new forms that can auto fill the same Customer info section and
other repeat info from just entering the primary key such like the
phone number of the returning customer or another suggested ways.

I don't know any programming but am waiting for the book I order to
start me on my way. "Beginning Programming for Dummies" If that a
good one or not more suggestion are helpful to get me going in the
direction I trying to accomplish.

The proper way to do this...

You have a table called Customers where you enter the data about each customer
exactly once. This table has a primary key CustomerID (or similar).

You have a table called Repairs where you enter the data about each
repair/service visit. In that table you have a field where you store the
CustomerID. That is ALL you store about the customer in the Repairs table
because everything else about the customer is already stored in the Customers
table.

On your Repairs form you can use a subform or other lookup mechanisms to
*display* additional information about the customer, but you do this by
retrieving that data from the Customers table, not by making redundant copies of
it.

 

[Guest]

The purpose I had in mind with all this was to have 4 tables made into forms
that can be printed out with the entire fields blank. One form, (new
customer, returning customer, and etc.) would be filled out buy the customer
them selves by hand first. Then I plan on filling out the info in access and
making a copy to give to the customer. If a returning customer does come in
I was hoping they or my self would not have to re-enter the fields I had on
file, but when I make a copy the name and other stored data will show up on
the new printed copy.

Of course this may not be the smartest way to make my receipts but is there
a way, for what ever reason, to make two or more forms that can auto fill
info from a previous form, if the two relate some how?