1 Reply Latest reply on Apr 16, 2009 8:26 AM by philmodjunk

    Update Field

    nunzionum

      Title

      Update Field

      Post

      In a DatabaseA I refer to a field of databaseB. If the field is modified in databaseA, how do I update the contents of the field in databaseB?
      FM Pro9 Adv; XP SP3

        • 1. Re: Update Field
          philmodjunk
            

          nunzionum wrote:
          In a DatabaseA I refer to a field of databaseB. If the field is modified in databaseA, how do I update the contents of the field in databaseB?
          FM Pro9 Adv; XP SP3

           

          Why would you need to? If the field is in TableA, it should not be in TableB also...

           

          Unless it's a matching field in a relationship or you have some unusual need to keep duplicate information in two tables. This is sometimes necessary but a good idea to avoid if at all possible.

           

          Tell us more about your two tables: databaseA and databaseB and any relationships that are involved.