I apologize if this has been dealt with before but I didn't find it on the site. While I've been using a template for my Art Studio since v6 (now on v8 and testing v11), I want to be able to start personalizing it. I'd like to be able to select the phone type (home, work, cell, fax, other) of my collectors in a pull down button which would trigger in the next field the corresponding field (home phone, work phone...etc.) for data entry and collection. All I have now is three separate entry fields to accommodate the information. Since most collectors provide a contact preference (either home or work numbers) it would be nice to use a pull down menu so that I can put the preferred contact number in the first triggered field (home, or work or other). I'd like to do the same with email and to address preference (work or home first). I know this must be a simple 'if, else, else' but since I am more creative than logical, I'd really appreciate some help in setting this up. Thanks in advance for any help.

I am also interested in this topic, as a beginner in FM10, I need a drop down item to trigger a second field to bring in an associated value. Then I can use that second field value for a basic calculation!

Cheers, Ben

ps. first post first question!

I am a newb but am making progress towards a simple database for a not-for-profit gourp. My experience is basically NIL.

Structure:

Table A: Location (dropdown list from Table , Location Rate (see question below), Attendee Name, Arrival Date, Departure Date, Total Days (Calculate: Departure Date - Arrival Date), Total Cost (Calculate: Location Rate x Total Days x 'Table C-DailyRate')

Table B: Location, Location Rate

Table C: DailyRate (global field)

I have sucessfully implemented the drop down value list in 'Table A - Location' from values 'Table B - Location' but want to get the Location Rate to come across also.

So I made it happen! Probably a work around and so am happy to hear others' solutions!

I made TableA:LocationRates a look-up field from TableB:LocationRates with a "do not copy" match value

with a Data entry of (number) 0

I made relationships graph of:

TableA:Location = TableB:Location

AND TableA:Location Rate X TableB:LocationRate

So on a new record in Table A, the LocationRate has a value of 0 before any data is input from the drop down menu of Location (based on a value list generated from TableB:Location).

Once a value is selected in TableA:Location the TableA:LocationRate looks up the value to replace it as the "X" places the value in no matter what is, as the relationship MUST be the same value for both fields with the AND scenario of the first line.

I hope this makes sense!

You can view my other search for help at

http://forum-en.filemaker.com/t5/Using-FileMaker-Pro/Drop-down-menu-to-populate-a-second-field/td-p/58469