I have a small mdb I've written to track exercise and calories consumed.

I have 2 small tables -

Food (All foods I might eat)
ID Autonumber
Food Text
Calories Number

Food Eaten (Food actually eaten)
Id Number
Food Text
Calories Number

And a simple query- foodsort - that sorts the Food table alphabetically by
Food and Calories

I created a form for the Food Eaten Table with a combo box that uses the
Foodsort query to pick a food and its related calories, and place it in the
Food Eaten Table.

It looks at the Foodsort query to pick the food, and place the related
calorie value in the calorie field of the Food Eaten table.

This works fine, except for foods that have the exact same calories, in
which case it always picks the first food with the same calories.

Can someone tell me what I'm doing wrong?