index | search | no replies | posting guidelines | help

login | register

Index » Products » ASP Report Wizard v2

search this forum:

:: Intermediate Table :: (4) Post a New Message | Post a Reply
Jun 7 2005, 10:07 PM	Intermediate Table Post a Reply
Goldestates since: Mar 27, 2005 from: Maryland	Ok guys, this is a good one. I need to grab data based on an intermediate table such as: "Show me all clients assigned to certain providers" In this case one provider can have more than one client and one client can have more than one provider. Enter the intermediate table sometimes called a many to many relationship in the form: Provider Table <-> Assign Table <-> Clients Table. I take it that the current evolution of your product is not quite at this point. Or is it? Joe
Jun 8 2005, 2:54 PM	Re: Intermediate Table Post a Reply
ghost from: Washington, DC	I just tried using Orders, Order Details, Products and Categories tables ------------------------- Ghost
Jun 8 2005, 3:54 PM	Re: Intermediate Table Post a Reply
Goldestates since: Mar 27, 2005 from: Maryland	Thanks but were you successful? Can you tell me the table connection string you used? Joe
Jun 8 2005, 4:15 PM	Re: Intermediate Table Post a Reply
whichman from: Laurel, MD	the tables relationship was as shown below: [Order Details].[ProductID]=[Products].[ProductID] AND [Products].[SupplierID]=[Suppliers].[SupplierID] ------------------------- Master of the Game
Pages: (1)   [1]

search this forum: