I have seen other users ask this question, but the responses all seem to be specific to their business (which is awesome customer service BTW), but I cant figure out how to translate it to my business needs... So here we go. I have a table that has my customers list... in another table, I need to keep a record of charitable gaming winnings. So I would like to have their ID number (as the key) auto populate their name and address into the charitable gaming log (2nd table). I am sure that didn't make any sense... but hopefully you can decipher it! It is clearly user error on my part, but I can't seem to figure it out! Thanks!
-
140 Points
Posted 9 months ago
QuickBaseCoach App Dev./Training (Mark Shnier), Champion
-
72,438 Points
Surya Avantsa, Certified Builder and Expert
-
3,038 Points
-
140 Points
Thank you both very much... So I have the relationship, and here is the relationship screen. However, when I go to "add a new game", it doesn't give me the option to put the Id number in... I have attached a screenshot of that as well.
Thank you all so very much for your help! I promise I am learning!
Thank you all so very much for your help! I promise I am learning!
Surya Avantsa, Certified Builder and Expert
-
3,038 Points
The Id Number field on the winner's log table form should be editable.
-
140 Points
sure. 
QuickBaseCoach App Dev./Training (Mark Shnier), Champion
-
71,308 Points
Melanie, that is weird. Is there any chance that the ID Number field on the form is set to "Read Only" on the form properties?
-
140 Points
it is not...
It is now allowing me to somewhat "edit" the field, but it is from a dropdown, not just a keyed in entry... any thoughts?
Maybe I need to just delete the relationship and start from scratch... if I was to do that, could you walk me thru exactly how to set up the relationships?
It is now allowing me to somewhat "edit" the field, but it is from a dropdown, not just a keyed in entry... any thoughts?
Maybe I need to just delete the relationship and start from scratch... if I was to do that, could you walk me thru exactly how to set up the relationships?
-
140 Points
I think I have figured out the problem... just not sure how to fix it.
The ID number box is, by default, a "record picker". While I have been able to find how to change how the "records" are displayed, I would like to change this from having to pick from a dropdown list, to just manually entering the number. There will end up being way too many customer ID numbers to scroll thru to find the write one for the game winnings log... if that makes sense.
The ID number box is, by default, a "record picker". While I have been able to find how to change how the "records" are displayed, I would like to change this from having to pick from a dropdown list, to just manually entering the number. There will end up being way too many customer ID numbers to scroll thru to find the write one for the game winnings log... if that makes sense.
Surya Avantsa, Certified Builder and Expert
-
3,038 Points
Reference fields are always a dropdown or a popup. You can't change it to a normal data entry field where you can type in a value.
QuickBaseCoach App Dev./Training (Mark Shnier), Champion
-
72,438 Points
QuickBaseCoach App Dev./Training (Mark Shnier), Champion
-
72,438 Points
