Re: Please help me with when I can use my key field

From: Bill Taylor (wtaylor51537_at_earthlink.net)
Date: 04/29/04


Date: Thu, 29 Apr 2004 19:44:34 GMT

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.

"Kate" <anonymous@discussions.microsoft.com> wrote in message
news:5dfb01c42ded$90503090$a401280a@phx.gbl...
> 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: What is "\s+"
    ... Allan Bruce schreef: ... The variable is called separator, but I dont know what it is, can somebody clarify? ... Hendrik Maryns ...
    (comp.lang.java.help)
  • Re: Identifying periods of High Volatility
    ... What do you mean by "construct" a bunch of ... I dont understand the relavance of the variables you ... Please clarify. ...
    (microsoft.public.sqlserver.datamining)
  • Re: How to add new toolbar to Internet Explorer?
    ... I dont know what "not working" means. ... You need to clarify it. ... that didnt help me, the project is not working for me, something ...
    (microsoft.public.vc.mfc)