Forum Discussion

SilverShi's avatar
SilverShi
Qrew Trainee
5 years ago

Need a solution on table to table relationships

Hi, I am having a problem with my App. So I have two tables, one called "leases", the other called "daily reports". "leases" is a table of each individual lease signed including info like property...
Relationships
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
I suggest that you first get the Property Record to calculate the current occupancy %.  Then on the daily report for that Property, lookup that value and then use a snapshot field to freeze its value.  Here is some help on snapshot fields 

https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.html

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------