I have a problem that i need to solve and have been struggling for some time and cant find anything that i can adapt on the forums.
I have 2 datasets one that contains clients diets and one that contains a list of foods and their nutritional values.
I have the page set up (NON dynamic not sure if thats right or wrong) with the 2 datasets on it as shown in the picture.
What i need is for when that page loads to recognize the entry into text box #food1 from data set #Diets, and then look down the dataset #MyFoods and return the field value of protein into text box #proteinValue
Currently #food1 & #proteinValue populate fine by simply linking them to datasets, what doesnt happen as there is no filter as such is that the #proteinValue doesnt change based on what it sees in #food1. what you see below in the #proteinValue text box is the value for orange juice as it is the first Prtein value in the database field.
Could use some help please.