2 Replies Latest reply on Mar 23, 2013 5:08 AM by RDDalbey

    Help with lookup

    RDDalbey

      Title

      Help with lookup

      Post

           I have a field in a scheduling worksheet that I want to do a lookup for in a related table.  The value is generally static with a yes or no value.  If the looked up field is blank, a decision is made for that particular instance.  When  I enter a value, it also changes the value in the related record.  

           How do I keep the value in the related record from changing?

           Thanks for any assistance offered.

           RD

        • 1. Re: Help with lookup
          philmodjunk

               Sounds like you have the wrong field on your layout.

               If you have this relationship:

               MainTable>------LookUpTable

               Maintable::_fkLookUpTableID = LookUpTable::__pkLookUpTableID

               For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained

               and you want to look up data from LookUptable on your Maintable layout...

               Make sure that the field where you are entering data is from Maintable, not LookUpTable or you will be modifying the related record.

               Sounds like you need to define a field in MainTable, specify the lookedUpValue auto-enter field option to copy a value into it from LookUpTable and then you place this field on your layout in place of the one that you have added from LookUpTable.

          • 2. Re: Help with lookup
            RDDalbey

                 Thanks

                 Indeed, my field in the MainTable was coming from LookupTable.

                 Fixed it and all is working as intended, thank you for your advice.