CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.

YesSoftware Forums -> CodeCharge -> General/Other

 Search from 2 tables with query

Print topic Send  topic

Author Message
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 and text column as meal.text. Should it be a left join?? or am I doing something else wrong??

Thank you

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.