Jump to content

Automatic update related fields


schotja
 Share

This topic is 2378 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

  • Like 1
Link to comment
Share on other sites

This topic is 2378 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.