So the goal is to pull the value of the max down to the Materials table. The the separate issue is how to block the save if the user edits more than the max.
Let do just the first part first. Then once it's working, post back and we can work on Part 2.
Make a new table called Focus Max. Create a single record in the able and then adjust permissions, so that no one, even Administrator, can add or delete records. The Record ID# of the single record will be 1.
Make a relationship where One Materials Cost Modifications has many Focus Max records. Edit the the Focus Max Record and select a Material Cost Mod record to be Active. Lookup any values you need, but specifically the Modification %.
Then make a relationships where One Focus Max record has many Materials.
For the reference field let it create one, but then edit the field properties for Related Focus ma to make it a formula numeric with a formula of 1. Then lookup the active Modification % down to Materials.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
