Please help me with when I can use my key field

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

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
 
Please clarify. Use this field for what? Generally, no. What do need to use
this information for? If you dont need information from the table then just
use the variable used to populate the field for your next opperation.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DSum update query with multiple fields 0
how query multiple fields into one field? 1
Conditional Query 1
Access 2007 SQL Stmt returns the incorrect value ? 3
Two Tables Insert Into with Select @@ Identity 2
Shift several columns in table 4
make field with sql or iif 5
How do I use my key? 1

Back
Top