Access XP + autonumber !!
no code this time .:D
I added autonumbering field , I added some values , then decided to delete them . the autoincrement field started this time not from 1 but from the last record was existed (7) . It tells me I can't because it's bound to another table .(I have one relation only) . How can I reset it to count from 1 or even 0 ??:rolleyes:
Re: Access XP + autonumber !!
Quote:
Originally posted by Pirate
no code this time .:D
I added autonumbering field , I added some values , then decided to delete them . the autoincrement field started this time not from 1 but from the last record was existed (7) . It tells me I can't because it's bound to another table .(I have one relation only) . How can I reset it to count from 1 or even 0 ??:rolleyes:
What do you mean 'it tells me I can't because it's bound to another table'? Who tells you? Are you getting an error? Also can't do what? Delete?
Anytime you have a relationship between two records in two tables (if referencial integrity is on) then you have to delete the children before the parent. It does that to maintain data integrity.
You can write a query to delete the parent record with all of its child records as well.
Also whats the difference if the autonumber field starts at 1 or 7?
Re: Re: Access XP + autonumber !!
Quote:
Originally posted by Edneeis
Also whats the difference if the autonumber field starts at 1 or 7?
Hmm , do you think I don't need to start from 1 ?? Till now I don't know if I'm going to use that number or not ? All what I want is to reset it (if possible) to start counting from 1 .