counting repetitions without repeating fields

[Ed Bowie]

I can't seem to figure this out and it should be very simple. I have 2 DB's. First called PROGRAMS (title, ID, length, second called SCHEDULE (Start time, end time, date). These two are related.

I put a program ID into the SCHEDULE DB and other info is inserted via a look-up.

WHAT I NEED is a count of which "play" I'm on when I insert the programID into the SCHEDULE. In other words, each program is inserted a varying number of times. I need to look at each insertion an see which insertion that is. For example: ID number 200 is inserted 5 times. I need to know that when I look at the second insertion it reflects (2), the 3rd insertion (3) and so forth.

I'm lost. THANKS

[LiveOak]

The easiest way is to look at a portal view in Programs. Unless a sort order is specificed for the relationship, the records will appear in creation order.

If you want a number field in Schedule which contains the occurrence # of a given ProgramID, it is best filled out when a new schedule record is created. Create a self-relationship in Schedule by ProgramID (SelfByPgmID). Create a field called Occurrence, Use a script to create a new record and set Occurrence in the new record to "Max(SelfByPgmID: ccurrence + 1)".

-bd