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?

Usually, you would use three tables (files, if you're using version 6) for this: Companies, Locations and the table where you want this to happen. Each location record would be related to its parent company, and once the user has selected a location, the corresponding company would be either looked up into another field, or - if you want a dynamic link - displayed directly from the company record.

I'd like to start off by saying thank you for your help so far. I hate to be a bother, so at anytime, if my questions are too simple/out there, do not hesitate to tell me to hit the books again.

--I understand setting up the 3 different tables. Done that.

--I understand how to setup a relationship between the them. Done that.

--As far as relating the record to its parent record, how do I relate it to the parent company?

Is this really for version 6?

i am using version 10.0 Advanced.

OK, then. I still don't know what the third table is, so I'll call it Projects. Assuming you have your relationships set up as:

Companies -< Locations -< Projects

just place the company name field on a layout of Projects. Since each project has only one location, and each location only one company...

Thanks,

Even though i am not sure i followed your instructions exactly, i think i got it to work.

Thanks again!

jerrad