OK, so 1 Building has many Rental Types and we need for the Building record to know what the Record ID# is for its Current Annual Rental Agreement.
No problem,
Make a Summary of the Maximum Record ID# of the Rental Agreements subject to the filter that it is Current and the Type is Annual. Call that [Record ID# of Current Annual Rental Agreement]. Pass that down to Tenants as that is where your Add Rental Agreement button lives.
URLRoot() & "db/" & [_DBID_RENTAL_AGREEMENTS] & "?a=API_GenAddRecordForm"
& "&_fid_9=" & URLEncode ([Record ID#])
& "&_fid_38=" & [Record ID# of Current Annual Rental Agreement]
& "&z=" & Rurl()------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
