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,
Why not just use a single date field instead of day, month and year fields? You can then format your date field to read: June 11, 2011 Saturday anywhere in either table where you need this format.