Getting Started

 View Only

Limit child record status with a checkbox

  • 1.  Limit child record status with a checkbox

    Posted 07-14-2020 16:08
    I currently have two tables in my app, 'Vendors' (parent) and 'Vendor Contacts' (child) - one Vendor to many Vendor Contacts.

    In my Vendor Contacts table, I added a checkbox named 'Primary Contact'. I'm trying to limit Vendors to allow only one Vendor Contact with the 'Primary Contact' status. I created a reverse relationship as well, where Vendor Contacts is the parent to Vendors, with Primary Contact as a lookup field in the Vendors table.

    At this point, I'm not certain what to do to next to make sure that Vendors only has one Primary Contact checked off where I can hide the checkbox if Primary Contact is already selected in any of the Vendor Contacts related to one Vendor.
    Vendors to Vendor Contacts
    Vendor Contacts to Vendors


    ------------------------------
    AR
    ------------------------------