Update record in related table
I have two tables, Samples and Locations. The user will go out and create new samples at the same locations each month. When they choose a location in the sample table, I'd like a field ( ex. pressur...
Forum Discussion
Correct, that is what I need to do. Ideally the pressure reading field would be numeric, but could be text if necessary.
------------------------------
Riley Cotter
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendOk, easy peasy.
Go to Relationship and make a summary field of the Maximum of the Record ID # of the children Samples record. Call it [Record ID of the most recent sample]
Then look that up back down to samples.
Then make a Summary field of the Maximum of the Pressure, but include a filter on the summary field setup that the Record ID equals the [Record ID of the most recent sample].
That's it! You now have a numeric field for the Pressure up on the a location record.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
