AnsweredAssumed Answered

Set Field By Name??

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


Set Field By Name??


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!