FM - Design Issue
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?
-Relationships.jpg
-ClauseFlagNexttoClauseText.JPG
-TypicalClauseExportFieldinLW.JPG
-ChooseableExport.JPG
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?
-Relationships.jpg
-ClauseFlagNexttoClauseText.JPG
-TypicalClauseExportFieldinLW.JPG
-ChooseableExport.JPG
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good point and it is the same principle as if you use a calc text field or an auto-enter text field. The former will always replace so the danger is losing your original; however, the latter can accidentally be overwritten and we have had a lot of data entry errors here.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, Will. This is enough info to solve the problem.
ASKER