Discussions

Expand all | Collapse all

How are lookup fields stored in a child table?

Jump to Best Answer
  • 1.  How are lookup fields stored in a child table?

    Posted 01-29-2020 11:15
    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
    ------------------------------


  • 2.  RE: How are lookup fields stored in a child table?
    Best Answer

    Posted 01-29-2020 11:18
    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
    ------------------------------