1 Reply Latest reply on Jun 13, 2011 9:35 AM by philmodjunk

    Combining table data



      Combining table data


      I am running FMP-9 on an iMac (running Snow Leopard).

      In my database, I have two tables connected through a relationship.  They are connected by fields called  "Day", "Month", and "Year".  I would like to update one field in one of the tables and have it update the other table.  I only want one field updated.  The field I want to update is not the day, month, or year fields.

      For example, table 1 shows "June 11, 2011".  Table 2 shows "June 11, 2011  Saturday".  How do I update Table 1 with "Saturday"?  Is this possible?

      Thanks in advance,