Record Picker Question
Hello All: I am hoping there is way to only show "Labor" Category Items/Records in the record picker when using Labor Cost Form. Similarly, "Material" Category Items/Records in record picker whe...
Forum Discussion
Hey Mark:
Not sure I am following your suggestion. I can't eliminate the relationship.
A little confused.
Sorry,
Dirk
------------------------------
Dirk Ruana
------------------------------
Not sure I am following your suggestion. I can't eliminate the relationship.
A little confused.
Sorry,
Dirk
------------------------------
Dirk Ruana
------------------------------
Hi Mark
I was hoping this could be accomplished with "Custom Data Rules."
But not having any luck.
Dirk
------------------------------
Dirk Ruana
------------------------------
I was hoping this could be accomplished with "Custom Data Rules."
But not having any luck.
Dirk
------------------------------
Dirk Ruana
------------------------------
- MarkShnier__You
Qrew Legend
Custom Data rules are something completely different and are used to validate data or block the save if the data is invalid.
I was not suggesting that you delete the relationship. Your question seemed to me to be saying that when selecting a labor cost code, you only want to see cost codes which are labor.
So make a report of the cost codes that are just for Labor and then set the form to use that report for the drop down list for that cost code table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- I guess I know how to make a report that just shows Labor Phase codes, but I can't figure out how to incorporate into record picker?
Do you create a Relationship between the report and the Labor Cost form? I thought you could only do that with tables?
Sorry for the confusion.
Dirk
------------------------------
Dirk Ruana
------------------------------- MarkShnier__YouI see a field on your screen shot for CSI - Phase code. That is a drop down field from a relationship, right? So go to the form properties for that drop down field and instead of letting the form use the default record picker fields, tell it to use a report instead. ie you specify that in the form properties. The report will be one that you will have made for this purpose which is filtered to only show labour codes.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
