I am using ADO to manipulate my table. i have an input table, then i will output several different tables, for the output table, how can i add an auto-increased ID field into my table? THANK YOU VERY MUCH FOR YOUR SUGGESTION :)
Programming
Last Comment
FaithRaven
8/22/2022 - Mon
bistrica
in table design set property of column to autonumber
dev_tek
Its simple just make that column as autonumber and when u insert record use UPDATE query with out inserting any value for that column.
twalgrave
Please specify further your requirements.
1) What database
2) Are you using ADO to actually create the table, or to return the data from an already-defined table
3) What are the restrictions on the auto-increased ID field (is it OK to have gaps in the numbers?)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
belinda_sg
ASKER
i use microsoft access to sort my database.
in fact, i am not going to create a table, i am using SQL to select certain records to my new table. so in one form, i use Microsoft Hierarchical FlexGrid Control to show one table, in the new form, i also use the same format, but i wanna add a new field named "S/N" so that i can know that how many records i have for the new table. thank you for you all's help...
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept twalgrave's comment
Please leave any comments here within the next seven days.