I seem to have forgotten how to count

[jhomer]

I have two tables 1. Events 2.Notes

Each event can have several notes

I would like to be able to number the notes as they corrispond to the Event.

By this i mean Event A has note 1 2 3 4

and Event B has note 1 2 3 where those notes are the 5th 6th and 7th note entered in that table.

can anyone help?

[Fitch]

If you make a self-relationship in the Note table by Event ID, and a number field in the Note table with this auto-enter calc:

Count( NoteSelf::Event ID ) + 1

This works, but if you are entering notes via a portal, you have to commit the record after each note entry. Not ideal.

So it might be just as well to NOT use auto-enter, but instead put the calc into a script that creates a new note record. And if that's the case, then rather than make a new relationship for this, your script could just count the related notes through the existing event::note relationship and add 1.