Forum Discussion

KatherineOakey's avatar
KatherineOakey
Qrew Member
5 years ago

Child record picker on 3 different parent record fields

I have a parent table Client.  The three fields of interest are Email, First Name, Phone.  Each are listed in the parent Default Record Picker. I have a child table Ticket.  The Ticket table has 3 ...
Relationships
KatherineOakey's avatar
KatherineOakey
Qrew Member
5 years ago
This 'solution' also doesn't do what I envision.  

I get the default record picker of 3 fields.  But, if I enter something that isn't the email, it wants to create a new client.

I would really like three different dropdowns; one for each of the 3 fields so someone who is using the Ticket form can choose which of the 3 fields to use to look up a client and then have the remaining two fields 'filled' in from the selected client record.

------------------------------
Katherine Oakey
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
This:
I would really like three different dropdowns; one for each of the 3 fields so someone who is using the Ticket form can choose which of the 3 fields to use to look up a client and then have the remaining two fields 'filled' in from the selected client record.

... is most confusing.  The idea of a drop down is to select a parent record.  You can search against any of the drop down fields to get a hit.  If the hit does not exist them you can allow the user to create a new Parent record on the fly.  That is how it works.

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