Jump to content


  • Posts

  • Joined

  • Last visited

JenKri's Achievements

  1. Thank you, this appears to do exactly what I am looking for. Unfortunately my Caspio plan does not allow me the use of triggers in tables. I am not sure if there is another way. If not I may just be out of luck
  2. I am trying to create a project auto number with a twist. Currently our numbering is a manual 7 digit entry using a 2 digit start representing a chapter(ie. 88), followed by 2 digits representing the year (ie. 21) followed by 3 digits which is the project number. I would like the project number to be auto generated so there are no duplicates and the person entering doesn't need to look up the last number. My thoughts were to have the following columns in the projects table 1. Chapter Number record (select option) 2. Year record (default to current year if possible) 3. Project Number - This however is the part I am stuck on, I would like this as an auto number but I would like the auto number based on the chapter & Year ie: 88-21-001 then when it is asked to create a new project number it would set the project number to 002 so it would come up 88-21-002 (this would essentially be a combined field). But if it is going under another chapter their first project would come up 77-21-001 and then when they add another it would default the project number to 002. So essentially I want it to look at Chapter number, then Year Number then say the next project would be 1 greater. I hope that makes sense Thank you for your time
  3. How Can I hide inactive records from my listbox on my Datapage? My listbox is linked to another table [Exams], this table has [ExamName] & [Status (Active/ Inactive)] Fields. I want the Listbox on the datapage to hide the Inactive Exams.
  • Create New...