I am developping a Database in access.I am tyring to make an access interface that will make a lot of things easier .Now I have a text field which is an Id for my table and it has Text as a datatype.How can I Auto Increment that Text Field,so that each time i add new record it increments automaticaly??F or example having 6 records,after cliking add button it increment by one.
THx
THx