1 Reply Latest reply on May 3, 2010 7:53 AM by Mystick

    Showing Records from 2nd Table



      Showing Records from 2nd Table



      In order for other forum participants to better help you, please provide the following information when posting:

      Using FileMaker Pro 10 Advanced on Mac OS X 10.6.2


      It's a simple database to track information about Bicycle Training rides and contains 3 tables - Ride_Data, Routes and Weather.


      Ride_Data Table contains fields for:  Ride_ID, time, distance, date, time of day, Max Speed, Average Speed, etc...

      Routes Table contains fields for:  Route_ID, StartPoint, Midpoint, EndPoint, Distance.

      Weather Table contains fields for: Icon_ID, IconName, and Icon (container field for holding .gif image)


      Created a new layout based on Ride_Data Table.


      Want user to select a weather type from a drop down based on the IconName field in the Weather Table, and have the corresponding Icon appear next to the Name.


      For example, a ride on May 1, 2010, 25 miles, in the morning.  Weather was "sunny". 


      "Sunny" is the data in Table-Weather, record 00002, field IconName.  The .gif held in the field "Icon" from the same record should appear next to the the Weather (iconname).


      Icons are being stored in the Weather table, which I might have already mentioned.


      Help?  I can't get the icon to appear.  It should also switch accordingly if the user selects a different choice from the Weather Type drop down (Field IconName)


      I've been using FM for a few years, but not very well.  Only scratching the surface, so relationships and so forth tend to confuse me.


      I want to be able to create an app from this that can be distrubuted to some friends I ride with as a windows executable.


        • 1. Re: Showing Records from 2nd Table

          In Ride_Data table, you should add a field name "Weather_ID".


          You create a relationship between table Ride_Data and table Weather using fields Weather_ID = Icon_ID


          Your weather value list should be on field Icon_ID from table weather + second field IconName.  Displaying only the second field if wanted.

          Then on the layout, you add the field Weather_ID from table Ride_Data, which should be a drop down list based on your value list. This will fill in the weather_id field and activate the relationship.

          Next to your drop down list, you add field Icon from table Weather.