autonumber problem

I am trying to design a database for my company, but my
knowledge of access is somewhat limited.

I have two tables: Customer (which holds all of the
customer information) and Product (which holds all of the
information on the products etc.) I then have a query
which is created from these two tables, and an input form
created from that query. So when I enter the customer
deatils it goes into the customer table, and the product
details go into the product table.

However, we have another category of product. What I would
like is a product2 table, linked to the customer, a new
query made from these and a form to input.

But, when I enter data into the form the data is
overwritten by the data already assigned to the autonumber
given. Eg: I enter Joe Blogs into the new form, and
instead of displaying that it shows Jane Doe, which is the
information I put into record 1 of the old product
category.

How do I get around this?

Thanks

Will

If you only have Customers, and Products, how do you know how these are
related? I believe you need a third table to show which Customers are
related to which Products...

.... or maybe I don't understand your situation.


--
Good luck

Jeff Boyce
Access MVP

This can happen when you open a form and data is already displayed.
One solution is to just use the record selector buttons to move to the
next record and avoid the Jane Doe record. Another solution is to
use two different paths for data entry and data editing.

When you open the data entry page you tell it to "add new record"
the form opens. This will give you a fresh autonumber when the
entry form opens.

Scott

I agree with the last poster that you should have a product table, customer
table, and a table that links the two, perhaps something like "orders."


"Will" wrote in message
...
I am trying to design a database for my company, but my
knowledge of access is somewhat limited.

I have two tables: Customer (which holds all of the
customer information) and Product (which holds all of the
information on the products etc.) I then have a query
which is created from these two tables, and an input form
created from that query. So when I enter the customer
deatils it goes into the customer table, and the product
details go into the product table.

However, we have another category of product. What I would
like is a product2 table, linked to the customer, a new
query made from these and a form to input.

But, when I enter data into the form the data is
overwritten by the data already assigned to the autonumber
given. Eg: I enter Joe Blogs into the new form, and
instead of displaying that it shows Jane Doe, which is the
information I put into record 1 of the old product
category.

How do I get around this?

Thanks