AnsweredAssumed Answered

Set Field By Name??

Question asked by SibenMadze on Mar 3, 2011
Latest reply on Mar 3, 2011 by philmodjunk

Title

Set Field By Name??

Post

I am an extreme noob to FMP and am currently using FMP11

I have 2 tables.

on the 1st table is a yes/no pop up button (field 1), a number field (field 2), and a pop up of cities (field 3) that returns a city based on a related field in the 2nd table.

on the 2nd table I have a field of category id's (field 1), a field of cities (field 2), and a corresponding field of milages per city (field 3).

what i need is to have the corresponding mileage amount for the city selected in field 3 of the first table appear in the number field (field 2) of the 1st table when "yes" is selected from the yes/no pop up button (field 1).

I think that maybe "set field by name" is the way to make this happen but I'm having some trouble getting it to work..

any help would be enormously appretiated!! Thanks!

Outcomes