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]