CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

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

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

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