5 Replies Latest reply on Nov 2, 2015 12:51 PM by evgomes

    We have an equipment log and we want to label pieces of equipment with numbers ONLY if they require emergency power.

    evgomes

      Sorry, to ask a crazy question but I am no where near a filemaker expert and I am working on a database that someone else created and they weren't an expert either.

       

      We have an equipment log and we want to label pieces of equipment with numbers ONLY if they require emergency power. We have an equipment log and we want to label pieces of equipment with numbers ONLY if they require emergency power. Currently the log has about 450 records of which only about 47 of the items require emergency power.

       

      So IF the Equipment Requires Emergency Power field answer is YES, THEN the Label number field should automatically generate a Label Number.

       

      I also see that this database doesn't have any primary keys.

       

      Please tell me this is possible. Thanks in advance.