CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 Listing Records from two tables linked by id

Print topic Send  topic

Author Message
Mark Weller
Posted: 10/02/2003, 9:52 PM

Hello all,
I have a database with companies in one table and products in another table; they are linked by companyID....I would like to have a page that would list all companies and under each company list all of their respective products, such as:

Company A
- Company A product 1
...
- Company A product n

Company B
- Company B product 1
...
- Company B product n
.....
Company N
- Company N product 1
...
- Company N product n

Is it possible to do it with CodeCharge Studio?
Thanks
Karen
Posted: 10/03/2003, 1:26 AM

Shouldn't be a problem. Just link the tables in the query builder and display them in a grid by selecting the fields from either table. Very easy to do.

Hope this helps!

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

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

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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