HELP with SQL queries

N

Nassir

I have Employees Table with 9 employee record already in the table i want to
insert a new Employee record in the table with INSERT INTO the primary key is
AutoNumber and i'm inserting from a form. How should i create this becuse i'm
getting error on this ? I'm using the Northwind databse employees table.
Please help
thanks
Nassir
 
A

Amy Blankenship

Nassir said:
I have Employees Table with 9 employee record already in the table i want
to
insert a new Employee record in the table with INSERT INTO the primary key
is
AutoNumber and i'm inserting from a form. How should i create this becuse
i'm
getting error on this ? I'm using the Northwind databse employees table.
Click to expand...

The form should handle the insert for you. You don't need to write any
queries to make it happen.

-Amy
 
M

Maurice

Nassir,

As Amy mentioned this is taken care of by the form of the Northwind DB. You
have to be more specific. Have you made your own form? What is the error
message you are getting?

Maurice
 
Top