Jump to content

I seem to have forgotten how to count


jhomer
 Share

This topic is 5649 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5649 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.