This is related to my last question. I have a LeaseWriter table and layout where the main body of the leases are written. Then, I have a LW_ClauseMaster table with an x relationship, 1 rec, and about 120 fields that contain lease clauses. I make these lease clauses chooseable by have a YesFlag field from a ClauseFlags table, which is related to the LeaseWriter table (not the LW_ClauseMaster table). If this is confusing, see the screen print.
With my last question, I was able to convert the 120 fields into 120 records (in ClausesbyRec table) in order to display these fields alphabetically in a portal. While that helps for display, I don't see how I can make a certain record/clause show in my LeaseWriter calc fields whereas it is easy when it is a field (see 2nd screen print). Additional complexity is that I'm not sure how to relate LW_ClauseFlags to clauses; I just put them side by side and check Yes makes the clause text show up in the "Chooseable" calc field (see 3rd screen print). How would you do this so there is only 1 table to keep updated?