TeoC

And... That was beautifully simple! The RecordNumber symbol works great for this simple need. Thanks so much!

Hi Comment, thanks for your reply. Since these numbers only represent the number of events that happened on a given day– the serial number could be something subject to change, and that would be fine. Basically, in a layout called "ThisDay", I want to show the user a list of the events planned for that day, and list them in order of start time. For example: #1: "Book Discussion with Bob" at 2pm; #2: "Film Analysis with Fran" at 2:30pm; #3: "FileMaker Basics at 3pm". If The 2:30pm event gets cancelled and deleted, then it would actually be ideal if the DailyEventID #2 gets reassigned to the 3pm event and so on for everything forward of that. So the option you described, to provide a count of how many other events are scheduled for the same day, and then number them according to creation order, sounds like it would work. I realize that basing it on creation order, would not consider the scheduled times, but that's ok. This is a pretty low-level tool for internal use that's just for assisting in planing event. Any help you could offer would be very much appreciated!

Hello, beginner level here, and I'm hoping this is maybe something easy? I'm grateful for any help. In a basic scheduling database, I have a table of unique Events, that each each record has a unique ID and Date (EventDate), and other fields connecting to another table of possible "Names of Events". I want to create an additional field in this Events table with an auto-entered serial number, starting at 1, that represents each event (record), that occurs on a new (unique) date. I keep thinking, it's a conditional statement that says "If the date in EventDate is Unique, then the auto enter value is 1. If it's the first duplicate found of EventDate, then the value is 2, and so on... I'm calling this the DailyEventID. If there's 29 events in a given day, the DailyEventID for the last record with that date is 29 and then on the next day, sets back to 1. I'd be grateful for any help!