In order to do this you would have to have a formula on the trail table that would calculate to the correct response for which is the parent price record. If the key field of the prices table is just the Record ID it would have to calculate the correct record ID or else you could change the key of the price table to be something more meaningful than Record ID and you would have to have a formula that would calculate to that value.
Example, the key field could be set to text which reflects the size range of the job.
0-1000
1001-2000
2000+
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
