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 "...
Forum Discussion
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
Qrew Legend
Qrew LegendWhen 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
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
------------------------------- MarkShnier__You
@
@You will need to have reverse relationships where 1 Window has many Quotes.
You up will ultimately need 10 of them. But start with One.
On on the right side will be min record #1
then look up any values you need down to the Quote.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------Mark,
I have the relationship already for 1 window to many quotes. But past here- I still am unable to follow the steps to get that to work. I couldn't find another post on here that explains it as well, but would be interested in seeing that because it feels like this is easy, I just haven't been able to follow.
Thank you,
Mike Klausing
------Original Message------
@
@You will need to have reverse relationships where 1 Window has many Quotes.
You up will ultimately need 10 of them. But start with One.
On on the right side will be min record #1
then look up any values you need down to the Quote.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------