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
|
|
|
|