AnsweredAssumed Answered

Combining table data

Question asked by David40 on Jun 11, 2011
Latest reply on Jun 13, 2011 by philmodjunk


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,