Drop-down menu to populate a second field
I am a newb but am making progress towards a simple database for a not-for-profit gourp. My experience is basically NIL.
Table A: Location (dropdown list from Table B), 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.
How do I get the Location Rate to come across when I make or change a selection in the Location Drop Down menu, thus making the calculation of the Total Cost for an attendee?
I appreciate any help in this regard. I'm using FM9 on Mac 10.5.8
I can also post screen shots of relationship or field types etc if that helps!