I'm getting reacquainted with FMP v10. I am attempting to create a field that results a certain answer based on a previous choice made by a user.
I have a locations (X, Y, Z) for Company A, locations (U, V, W)for Company B, and locations (R, S, T) for Company C.
If the Location field is the first field the user would choose from a predefined dropdown list (R, S, T, U, V, W, X, Y, Z) I would like the corresponding company Name (A, B or C) to then populate the box next to it. How would I accomplish that? By using a script?