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