AnsweredAssumed Answered

Chart data from a Value List

Question asked by JohhnyHilly on Oct 6, 2013
Latest reply on Oct 28, 2013 by philmodjunk


Chart data from a Value List


     I am trying to chart data from a value list but am having no luck displaying the data. I need help to make sure the tables and relationships are right and for this to work.

     Vehicles::_pkVehicleID to Oil Samples::_fkVehicleID

     In the Oil Sample table I have fields such as IronContent and ChromiumContent and it is with these values I want the value list to be based on. I have a global field, gFindContent in the Oil Sample table and I have written a script to get a found count as follows (there is where my problem is, as it doesn't find the data from the gFindContent drop down list of IronContent and ChromiumContent).

     Set Variable [$Veh; Value:Oil Samples::_fkVehicleID]

     Set Error Capture [On]

     Enter Find Mode[ ]

     Set Field [ Oil Samples::_fkVehicleID, Oil Samples::gFindContent]

     Perform Find