Hi,I am trying to customize an entry to a form dependent on whether an entry has been done in the another field from the same table "Dispatch ID" shall be auto computed as max(Dispatch Id)+1 value from another table(Cold Chain Box Log) if "Box ID" ha...

Hi,I have a to build a list with enum dependent on another table key based on criteria if its available and activeCurrently I tried -SELECT(Cold Chain Box[Box ID], and(Cold Chain Box[Active/Inactive]="Active",Cold Chain Box[Current Status]="Available...