Allow single record to have checkbox set

MikeBrady
Qrew Trainee
3 years ago
Hi Laura, I want to do this across a single table. I am adding records for our current manpower count, but want to keep the old records. So I was hoping to add a record, and set it as "Active", and automatically unset the previous "Active" record in the same table.

------------------------------
Mike Brady
------------------------------
- LauraThacker
  Qrew Captain
  3 years ago
  I would probably set it up this way, on the assumption that the most recent entry is the active record.
  
  1. Build an ADMIN table (hidden from users).
  2.Create a single-record in your ADMIN table
  3. Create a relationship between your ADMIN < RECORDS (don't know what yours are called) table
  4. Build a summary field to pull the Maximum [Record ID#] of the RECORDS table to the ADMIN table (find out the highest Record ID#)
  5. Add LOOKUP of [Max Records Record ID#] back into the RECORDS table via the relationship
  6. Add a formula-checkbox field with the formula
  
  [Record ID#] = [Max RECORDS Record ID#]
  7. Change the [Related Admin] reference field to a Formula-Numeric field, with a fixed-value of 1 (this means that every single RECORDS table record is automatically connected to your ADMIN table record and is "feeding" the record information back to the Admin table so that your RECORDS table can use the maximum record id# value to determine whether the latest one is the 'active' one.
  
  There are other ways to do this too; but this would be self-adjusting and require no extra work.
  
  ------------------------------
  Laura Thacker (IDS)
  laura@intelligentdbs.com
  (626) 771 0454
  ------------------------------
  - MikeBrady
    Qrew Trainee
    3 years ago
    Thank you Laura, that works perfectly. I appreciate you taking the time to help.
    
    ------------------------------
    Mike Brady
    ------------------------------

Forum Discussion

Allow single record to have checkbox set