Automatic solve numbering problem

[kissbalazs]

hi!

I would like to ask for help to solve a numbering problem.

I have 3 fields. It should work the following way. Field3 should get/generate the automatic number by watching cell field1 and field2. the values of field1 and field2 would be assigned manually.

like this:

field1 field2 field3

2008.002 04.05 1

2008.002 04.05 2

2008.002 04 1

2008.002 04.05 3

2007.011 04 1

2007.011 04 2

So if there are already identical field 1 and 2, than the ordinal number should jump +1.

And all of this should happen automatically.

Thx!

[LaRetta]

Hi kissbalazs,

If a User changes a number, should the numbers adjust on all the subsequent numbers? What if a record is deleted? What if the record set is sorted; should the numbers adjust? What is the intended purpose for field3? Is this going to be used in served environment?

I know ... lots of questions. For a calculation (excluding summary) to *see* other records in the same (or another) table, you need a relationship. To best answer, we need some of these questions answered.

ADDED: I should say up front that, if this is for creating unique IDs of any kind then I recommend against it. There are ways but ... i don't even want to go there

[kissbalazs]

This would be a contract indexing system and I would need the generation of contract number.

It should work the following way:

Step 1 - user sets field1, which is the number of the job.

Step 2 - user sets field2, which is the type of the contract.

After this the system should generate a serial number into field3 considering the values of field1 and field2.

Example:

field1 field2 field3

2008.002 04.05 1

2008.002 04.05 2

2008.002 04 1

2008.002 04.05 3

2007.011 04 1

2007.011 04 2

If the user changes field1 or field2 the field3 serial number will be re-generated.

Yes, most likely it will be running in server environment.

I tried the "count of" solution, which worked fined, but there only field2 could be set.

I attach an example, that is how far I got.

I would have another question for the "count of" solution:

is it possible that the "sorted by" element of "count of" does not work with a field whose type is not text but calculation?

thx a lot

[comment]

This would be a contract indexing system and I would need the generation of contract number.

...

If the user changes field1 or field2 the field3 serial number will be re-generated.

Are you sure about this? You want to generate a contract number that may change at some point - for example, if a previous contract in the same group is deleted?

What exactly does the data in field1 ("2008.002") and field2 ("04.05") signify?

---

See also:

http://fmforums.com/...post__p__347655