Let's say I've got tables People and Meals. I could join them with table PeopleMeals, that shows what meals people like to eat. A standard many-to-many mapping would work great.

But now, pretend I want to keep track of a person's favorite meal. I could add a column to PeopleMeals called IsFavorite.

Is there a way to access this extra column without creating a PeopleMeals class and doing two one-to-many associations. This seems a little complex for such a simple instance:

People <--> PeopleMeals <--> Meals

Thanks!

Norman