Forum Discussion

jlattner's avatar
jlattner
Qrew Member
14 days ago
Solved

Lookup Field not pulling Data

very new to Quickbase.  I believe I have followed all of the instructions on adding a lookup field to a new record form.  I have the relationship between the 2 tables established and am trying to add the field to the child table.  It gives me the dropdown list the way I would expect but does not show any of the data that is in the parent table.

  • When you say this: 

     It gives me the dropdown list the way I would expect but does not show any of the data that is in the parent table.

     

    If the symptom of the problem is that the drop-down list does not properly identify the parent record that you're selecting so that you were seeing a bunch of kind of blank records to choose from, then what you would want to do at a minimum is to go to the parent table and the advanced settings and choose up to three record picker fields that will help the users pick records. 

    But if you are saying that you successfully select a parent record, and yet the look up fields into the child table are not populating then that would be very unusual. Actually kind of impossible. Let me know if it's the first problem or the second problem.    If it's the second problem that I'm happy to jump on a quick Zoom call with you to sort it out. If it's the second problem, then I would be happy to jump on a quick Zoom call with you to sort you out.   Contact me directly at mark.shnier@gmail.com

     

  • When you say this: 

     It gives me the dropdown list the way I would expect but does not show any of the data that is in the parent table.

     

    If the symptom of the problem is that the drop-down list does not properly identify the parent record that you're selecting so that you were seeing a bunch of kind of blank records to choose from, then what you would want to do at a minimum is to go to the parent table and the advanced settings and choose up to three record picker fields that will help the users pick records. 

    But if you are saying that you successfully select a parent record, and yet the look up fields into the child table are not populating then that would be very unusual. Actually kind of impossible. Let me know if it's the first problem or the second problem.    If it's the second problem that I'm happy to jump on a quick Zoom call with you to sort it out. If it's the second problem, then I would be happy to jump on a quick Zoom call with you to sort you out.   Contact me directly at mark.shnier@gmail.com

     

    • jlattner's avatar
      jlattner
      Qrew Member

      It seems like it is closer to the second problem.  I have gone into the Advanced settings and all 3 record picker fields are selected.  I will send a screen shot to you directly via email.  Thank you.