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
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
Your application structure will need to be a little more complex to achieve this. Instead of just Leases and Daily Reports, you'll have to have another table that is a child to both of these - possibly a Lease Reports table or something. This is the table that you would use to capture the Lease information as of that date - using Snapshot fields, probably. 

If you're comfortable with Automations, you could setup something to automatically generate these records each day, so that the Property Managers would just need to complete any additional information that might be necessary.

------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Further to Blake's post above, I was assuming that you actually have at least 3 tables in your app including Properties and that there a Relationship where 1 Property has many Leases.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • SilverShi's avatar
    SilverShi
    Qrew Trainee
    5 years ago
    Hi Mark,

    Thank you for your link! You're right, I have a third table which concludes the leasing data by properties, and that table is the parent of "leases". 

    I will try if I can get what I want using the snapshot field. Thanks again

    Best,

    ------------------------------
    Silver Shi
    ------------------------------