HI. I have been able to create a record with duplicate entries using an INSERT command that incorporates a SELECT command. Once my new record has been created, I need to get the number of an Autonumber filed for the new record so I can make entries in a couple of secondary tables. Any suggestions?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.