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,