Hi, I am using an Access DB and am using the INSERT INTO statemeant to add an entry to a table, how do i get the ID for the entry that I have just inserted (the Autonumber). I am currently using a second SELECT query to retrieve the field using the values that were inserted, but this doesn't look tidy and has possible problems (integrity and performance),
Thanks, Chris Cormack British Telecommunications plc Registered office: 81 Newgate Street London EC1A 7AJ Registered in England no. 1800000 This electronic message contains information from British Telecommunications plc which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. Activity and use of the British Telecommunications plc E-mail system is monitored to secure its effective operation and for other lawful business purposes. Communications using this system will also be monitored and may be recorded to secure effective operation and for other lawful business purposes. Any views expressed in this email do not reflect those of BT and any of partners and assosiates. Responsiblity for the opinions expressed are those of the sender only -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
