Forum Discussion

MikeKlausing's avatar
MikeKlausing
Qrew Assistant Captain
6 years ago

Take related record ID and display text

I have a child table embedded in a form that allows our users to select quantity and type of an item. From there I am calculating costs of total "windows" for example.  If they want (2) of window "...
Relationships
RyanStanford1's avatar
RyanStanford1
Qrew Captain
6 years ago
I believe what you need to do is based off of those Min Rec ID#, build relationships to get the related fields.

------------------------------
Ryan Stanford
------------------------------
  • MikeKlausing's avatar
    MikeKlausing
    Qrew Assistant Captain
    6 years ago

    I have messed with the relationships some and haven't figured out what I am doing wrong as of yet. I can see the related window and the window size on my child table. But in the picture in the original post is from my form. I want the related window size for each "minimum record ID" field to show up on the form as well.

     

    Thank you,
    Mike Klausing

     



    ------Original Message------

    I believe what you need to do is based off of those Min Rec ID#, build relationships to get the related fields.

    ------------------------------
    Ryan Stanford
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      When you have a relationship and the Key field of the parent table is a meaningless Record ID# field, then you need to do a lookup field for a field which will be meaningful to your users. Then edit the related parent field and in its field properties you set the Proxy field.  That is the "better dressed" version of the [related parent] field which can be seen by the public.  Then put that proxy field on the form instead of the Related Parent field.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      markshnier2@gmail.com
      ------------------------------
      • MikeKlausing's avatar
        MikeKlausing
        Qrew Assistant Captain
        6 years ago

        Mark,

        Here is my lookup but I think its in the wrong spot right? It shows on my child table.

         


        I still am unsure of what I'm doing wrong to get these:

         

        To look like this:

         

         

         

        Thank you,
        Mike Klausing

         



        ------Original Message------

        When you have a relationship and the Key field of the parent table is a meaningless Record ID# field, then you need to do a lookup field for a field which will be meaningful to your users. Then edit the related parent field and in its field properties you set the Proxy field.  That is the "better dressed" version of the [related parent] field which can be seen by the public.  Then put that proxy field on the form instead of the Related Parent field.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        markshnier2@gmail.com
        ------------------------------