Suren
1. in the relationships graph create a copy of the table (YourTable2)
2. create a relationship between the two tables based on City
(YourTable::City=YourTable2::City)
3. create a number field (CitySerialNumber) with auto-enter calc:
Max ( YourTable2::CitySerialNumber) + 1
this calc must be evaluated in the context of YourTable
and "Do not replace field contents" must be UNchecked
NB: If a record is deleted it's serial number will NOT be replaced
(unless it was the last record created for that city)
cheers
Tom
On 31 Jan 2007, at 18:23, Suren Thambirajah wrote:
HI,
I have a small DB. I have field call “City” and it’s got 13 plus
cities.
Now I’m trying to crate serial number base on city every time I
crate a new record.
If I have choose Ottawa I want the serial number 1, 2, 3, 4, 5 etc.
If I choose Montréal should be 1, 2, 3, 4, etc.
How can I do that?
--
Suren
