Insert or update statment?

Results 1 to 3 of 3

Thread: Insert or update statment?

  1. #1
    Join Date
    Dec 1969

    Default Insert or update statment?

    MS Access 2000<BR><BR>I have a table with 3 fields: ID(autonumber), NAME(text), PRODUCTS(text).<BR><BR>There are already 61 records in it.<BR>Let&#039;s say I create an HTML form with Name and Product fields.<BR><BR>Can I use an update or insert statement to make it the 64th record and so on (keep adding records)?<BR>I&#039;m asking because I&#039;m under the impression that I had to have WHERE in there and the WHERE is just the next ID (autonumber).<BR><BR>I may be looking for a Create field type of statement but I&#039;m not sure.<BR>

  2. #2
    Join Date
    Dec 1969

    Default Crosspost answered in Database Q & A <eop

    FAQ #110

  3. #3
    Join Date
    Dec 1969

    Default negative

    as long as it&#039;s autonumber, all you need to worry about when adding a record is the name and products fields. Autonumber will increment AUTOmatically. :)<BR><BR>And in your update statement, you&#039;ll need &#039;where id = &#039; & request("id")...<BR><BR>just save the id in a hidden element in the form.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts