Forum Discussion

GoldenWest's avatar
GoldenWest
Qrew Member
5 months ago

HOW TO AUTO CHOOSE A LOOK UP FIELD INSTEAD OF CHOOSING FROM DROP DOWN?

I HAVE A LOOK UP FIELD, BUT IT ALWAYS GO FOR MAXIMUM NUMBER OF RECORD ID OF PARENT TABLE, BUT I DON'T WANT TO SELECT ON IT. IT THERE IS A WAY FOR ME TO AUTO CHOSE THE RECORD ID I WANT AND NOT TO CHOSE FROM THE DROP DOWN? I DON'T WANT TO CLICK ON IT AND SCROLL ALL THE WAY DOWN TO CHOOSE THE MAXIMUM RECORD ID NUMBER OF OTHER TABLE, IT COST ME A LOT OF TIME.



------------------------------
Golden West
------------------------------

3 Replies

  • Use a form rule to change the value of the related field to the max record id since you already know it



    ------------------------------
    Michael Lucas
    ------------------------------
    • GoldenWest's avatar
      GoldenWest
      Qrew Member

      CAN YOU TALK MORE ABOUT THIS PLEASE, I WOULD LOVE TO HEAR YOUR ANWSER.



      ------------------------------
      Golden West
      ------------------------------
      • ChayceDuncan's avatar
        ChayceDuncan
        Qrew Captain

        Golden - to clarify something from your original comment and Michaels suggestion - when you say the 'Max Record ID#' of the parent table - do you actually have a field that represents the max ID - or is it the case that you have a dropdown on your form, and in that you are always scrolling down because you always want to pick out the max record ID during your entry?

        I'm assuming the latter based on reading your full post. If thats correct - you can do something quick/easy and just reverse the order of your dropdown and sort highest to lowest on RID so that the max RID is the first option - not the last. The other option is to actually use your architecture to summarize a value into your parent or some other table of what the Max Record ID# is and then create a form rule per Michaels comment. 


        IF you already have a field that represents the max record ID# - then your form rule would just be something like: 

        When Related Parent is blank change value of Related Parent to Max Record ID#



        ------------------------------
        Chayce Duncan
        ------------------------------