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

 how to make search with 2 tables?

Print topic Send  topic

Author Message
symcox
Posted: 12/19/2003, 11:54 PM

Hi all,

i am having 2 database tables,

one is products table

one is it's manufacturing company(company table)

in my product table,there is a company ID.

how can i search products by giving company name?.the products table only having company ID field.

anyone plz.thanks in advance.



mkmind
Posted: 12/20/2003, 12:37 AM

Hello.
Put an Listbox in the search Form for searching the company name.
Boundcolumn is the ID and Textcolumn are your companynames.

sorry about my english

If you can not make this and you need an Textbox for the companyname in the search Form you can make a workaround.

Go from the searchform to an new Page, look in before show if the companyname is in your db, dlookup the ID from the company how was write in the textbox.
If dlookup is not emty you can make a header to your Gridlist with the ID

I hope you understand me.

By Martin
RonB
Posted: 12/20/2003, 8:20 AM

By making the result grid a combination of the two tables through a join. You do not have to show all the info from the company but you can still do a search on company name and get all products from that comapny as a result.

Ron

   


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

Web Database

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.