Automatic update related fields

[schotja]

Greetings,

Been away from FMP a while and having a brain fart.

Two tables with the second table that needs fields from the first table updated ie(Color in table one needs to be automatically updated in table two)

Table two (color)is a calculation and sometimes color in table one changes and i'm wondering if there is a way fmp updates table two without running a loop or some other manual proceedure.

 

Thank you,

 

Jared

[comment]

Your question is difficult to understand. In general, there should be no need to "automatically update" fields in another table.

If you have two tables in a one-to-many relationship, let the parent table store the information describing the parent (and only the parent), while the child table will store information describing the child (and only the child). The only information regarding the parent that needs to be stored in the child table is the ParentID - and that field should never change (unless the child is being transferred to another parent).

To display parent data on a layout of child. place fields from the parent table directly onto the layout.