Re: Please help me with when I can use my key field
From: Bill Taylor (wtaylor51537_at_earthlink.net)
Date: 04/29/04
- Next message: Gary Walter: "Re: help with delete query"
- Previous message: Bill Taylor: "Re: Save a filter (from table) as a query"
- In reply to: Kate: "Please help me with when I can use my key field"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Gary Walter: "Re: help with delete query"
- Previous message: Bill Taylor: "Re: Save a filter (from table) as a query"
- In reply to: Kate: "Please help me with when I can use my key field"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
