From Nantucket
|
Posted: 07/13/2005, 5:36 AM |
|
I am relatively new to Code Charge and am having trouble with a search builder.
I have 2 tables, one of menu items the other of meals. The ID from the meal table is joined with the meal column in the menu table. In the search I want a list box with the meal.text so the viewer can view all menu items from a particular meal. I did a query with a right join menu.meal to meal.ID. I get nothing in the search. I also specified the Data Source as Meal table, Bound column as meal.id and text column as meal.text. Should it be a left join?? or am I doing something else wrong??
Thank you
|
|
|
|