HELP with SQL queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top