Hello folks,
I'm building a nutrition database to keep track of my eating habit. I know there's ton out there but I want to do it on my own you know?
Anyway there's a tiny issue that I cant seem to find the answer anywhere. Google is great but I cant seem to figure out the right key word to use to find the answer. Argh!
Ok, I have a table [food_by_calories] that has two columns which are [food] and [calories].
an example would be like this
[Food]..............[Calories]
Hamburger......350
Banana............40
Now, I have a look-up drop down menu that goes to the table and I can select any from the first column with no problem. I also have a text field right next to it that I want to automatically display calories depending on which one I select in the drop down menu.
Is there a way to do this?
Thx