Forum Discussion

JeffreyPierce's avatar
JeffreyPierce
Qrew Trainee
5 years ago

How are lookup fields stored in a child table?

When a child table has a lookup field added, does the parent data in that field get duplicated and stored in the child table, thus enlarging the child table by the full size of the looked up data?  Or is there just some kind of "pointer" stored in the child table, which enlarges the child table to a much lesser degree?  #Relationships #tablespace​​​​ #Lookup

------------------------------
Jeffrey Pierce
------------------------------
  • Lookup and summary fields do not count for space.  They are "free".

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • Lookup and summary fields do not count for space.  They are "free".

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------