Please help me with when I can use my key field

From: Kate (anonymous_at_discussions.microsoft.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 06:26:22 -0700

I have some SQL where I Insert into a table with a primary
key field that is an Autonumber. Once I have done that can
I then use this field without having to go and read the
record?

I.e. Table1 with field1 as autonumber, field2, field3

Insert into Table1 (field2, field3)
Values ('X', 'Y')

Update Table2 SET [Sequence] = table1.field1
Where etc

I'm using ACCESS 2002 (and 2003)

If not then how do I retrieve the record so I can use the
keys value?

Thank you

Relevant Pages

  • Re: append query with visual basic
    ... To explain my query a ... little more, I didn't post it, because the SQL is long. ... I left the append parameter for the key field out, ... The key field is ChemicalID. ...
    (microsoft.public.access.queries)
  • SV: Novice ODBC Remote Views access Goldmine (dBase) tables
    ... There's a vastly enhanced SQL language. ... need and use with remote views is the SQL of the ODBC driver you're using. ... If GoldMine SQL is Standard SQL your remote views can be switched to any ... > just set all fields to be updateable except the key field since I ...
    (microsoft.public.fox.programmer.exchange)
  • Re: question about SQL statement
    ... You need to tell us at least what sort of database you are using (the SQL is ... How are you connecting to it: ADO, ... are, the key field if any, and any other details that might be useful. ... detail information on the record. ...
    (microsoft.public.vb.general.discussion)
  • BindingContaxt
    ... I am trying to insert a new record into a sql table, that has a field that is ... a key field. ... DataRowView drvDetail; ... DataView vueDetail; ...
    (microsoft.public.dotnet.framework.adonet)
  • How do I use my key?
    ... I have some SQL where I Insert into a table with a primary ... key field that is an Autonumber. ... If not then how do I retrieve the record so I can use the ...
    (microsoft.public.access.gettingstarted)