A basic question?

Hello all!,
This is probably pretty simple. I think I'm trying to hard on this, and
can't see the logic. If I have a table(products) with a productID, prodname.
And a another table called user, with UserID and name. And I add a UserID
column to my Product table. How can link the userID to the product ID. So i
f
user1 sells, apples and grapes, apple and grapes will have UserID1 matched t
o
it, just like userid2 sells Oranges, and so on. Hopethis makes sense!
Thanks!!
RudyHi Ruby
This looks like a database design issue. To reduce the redundancy,
to can create a new Table UserProducts and add UserID and ProdID to it
Ex:
User ID | Name
1 | User-1
2 | User-2
3 | User-3
ProdID | Name
1 | Apples
2 | Grapes
3 | Oranges
UserID | ProdID
1 | 1
1 | 2
3 | 3
Hope this answers the question
thanks and regards
Chandra
"Rudy" wrote:

> Hello all!,
> This is probably pretty simple. I think I'm trying to hard on this, and
> can't see the logic. If I have a table(products) with a productID, prodnam
e.
> And a another table called user, with UserID and name. And I add a UserID
> column to my Product table. How can link the userID to the product ID. So
if
> user1 sells, apples and grapes, apple and grapes will have UserID1 matched
to
> it, just like userid2 sells Oranges, and so on. Hopethis makes sense!
> Thanks!!
> Rudy|||Thank you! That does make sence. I knew I was making it more difficult tha
n
it had to be.
Thank You!!
Rudy
"Chandra" wrote:
> Hi Ruby
> This looks like a database design issue. To reduce the redundancy,
> to can create a new Table UserProducts and add UserID and ProdID to it
> Ex:
> User ID | Name
> 1 | User-1
> 2 | User-2
> 3 | User-3
> ProdID | Name
> 1 | Apples
> 2 | Grapes
> 3 | Oranges
> UserID | ProdID
> 1 | 1
> 1 | 2
> 3 | 3
> Hope this answers the question
> thanks and regards
> Chandra
>
>
> "Rudy" wrote:
>

3rd-party report editors

Does anyone know of any products out there that allow end users to control the layout and fields of a report without having to install any special software on their machine?SQL 2005 has a web-based Report Builder which may do the trick for you.
SQL 2000 + Panorama Enterprise Report Builder is another option.|||You could also try ActiveReports by Data Dynamics - http://www.datadynamics.com/Products/ProductOverview.aspx?Product=ARNET2. It integrates very smoothly with .NET programs, and all the DLLs can be redistributed for free (vs. Crystal where design components require a per-seat license). Not quite as slick as Crystal or Reporting Services, but the cost and flexibility make it worth looking into.

josh|||Hi Josh,
I looked into ActiveReports and while it did look promising it seems the end-user designer only applies to WinForms.
Thanks for the suggestion, though.

3rd Party Source Control that leverages VSS

I noticed from this link:

http://www.aspfaq.com/show.asp?id=2495

There are four well known products that are used by medium to large size shops to help aid in change management of SQL Environments.

- AbaPerls
- DBGhost
- MSSqlExpress
- SQL Source Control

Does anyone currently use any of the above? Could you briefly explain your likes an dislikes and if you have reviewed any of the other options above when you had to make a decision as to which product to use?I guess no one uses 3rd party tools to complement Visual Source Safe??|||I did not know anything complemented VSS. We certainly don't ;-).